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 |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2004-11-05 : 05:51:40
|
| HiI have some questions:(1) I have developed database. Is it possible to create another copy of this database, with all the tables and data in it. (2) If I have a database on my local machine, how I can upload it onto a remote machine, with all the tables structures. kind regards |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-11-05 : 06:01:37
|
| Hi!(1) The easiest way would probably be to backup the database and restore it under a different name. Lookup BACKUP DATABASE and RESTORE DATABASE in Books Online.(2) If you want only the structure you can script your database using Enterprise Manager ("Generate SQL Script" somewhere under the right-click menu on the database). If you want everything, you can use the method mentioned above.Regards,Andraax |
 |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2004-11-05 : 06:39:41
|
| thanks for the answer. I have used Generate SQL Script. But now, I am unsure how to run this script in MSSQL to create the new table structure. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-11-05 : 07:23:56
|
| copy the script into a QA session, select the appropriate database to target against and then run it. |
|
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2004-11-05 : 07:44:11
|
| thanks |
|
|
|
|
|
|
Duplicating databases / tables