Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2007-08-02 : 12:03:00
|
| Hi FriendsWe have a database that contains tables having 4 million recordsCan you tell me a way to copy the schema of the Database to a new database.Generate SQL Script...Is it the only option or can i use the DTS packageWhich is the most reliable one?RegardsVivekVichttp://vicdba.blogspot.com |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-02 : 12:27:50
|
| >>>Generate SQL Script...Is it the only option or can i use the DTS packageBoth are realiable, tested, proven processes. Which one more suits your needs is more of the question here. do you just need the schema or you need the data too? If you just need the schema, you can genrate the script and compile it on the target server. Now if you need data, you can use DTS for it. So,perhaps, both these processes can be useful for you.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Copying the Database Schema