|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 28th, 2005, 12:06 PM
|
|||
|
|||
|
copying database
how to use SQLDMO to copy a database to
a new database (allow custom path) with all the tables, data ,view , relationship (everything) exactly as the 1st database
|
|
#2
March 6th, 2005, 09:48 PM
|
||||
|
||||
|
Quote:
What's SQLDMO?? I know you can use the Data Transformation Services (DTS). If you'd like to copy the db exactly into another one, use DTS and choose to "copy objects and data between SQL Server databases." Be sure to have copy data and copy all objects checked. That should be it hopefully. Good luck! 
__________________
Keep it Prodigy, Keep it Real
|
|
#3
March 6th, 2005, 10:11 PM
|
||||
|
||||
|
You have several options of doing this.
1) You can generate a SQL Script of the database, then execute that script within another database. 2) Using SQLDMO you can copy the entire database to another database using the Database.Transfer method. 3) Using SQLDMO you can do something similar to 1, using the Database.Script method. SQLDMO stands for "SQL Server Distributed Management Objects" To learn more about SQLDMO, click the link below. SQLDMO Info
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > copying database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
