|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
19/10/2006, 05h42
|
#1 |
Messages: n/a
Hébergeur: |
Copying database using smo code
Hi,
Is it possible to automate copying of a SQL 2000 database into 2005 database? I want this to be done thru code and not by using the copy wizard. I want to accomplish this using SQL SMO. SMO provides APIs for backup and restore but I was unable to find anything on copy database. Any interms of code snippets or links would be very much appreciated. Thanks, Guru |
|
|
19/10/2006, 09h19
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Copying database using smo code
Copy wizard detaches database, copies files and attaches them back to the
new (and old) server. I do not know how exactly to do this with SMO, but I hope you have a starting point for searching. -- Dejan Sarka http://www.solidqualitylearning.com/blogs/ "Guru" <gurunv@gmail.com> wrote in message news:1161232959.216186.221450@m7g2000cwm.googlegro ups.com... > Hi, > > Is it possible to automate copying of a SQL 2000 database into 2005 > database? I want this to be done thru code and not by using the copy > wizard. > > I want to accomplish this using SQL SMO. SMO provides APIs for backup > and restore but I was unable to find anything on copy database. > > Any interms of code snippets or links would be very much > appreciated. > > Thanks, > Guru > |
|
|
|
| Outils de la discussion | |
|
|
