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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-05-13 : 02:57:46
|
| I have one database called abc, now i created another database xyz, now i want to move all the tables,schemas which was in abc to xyzhow to do it in sql server management studio 2008 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-13 : 03:00:44
|
| Do you want to1) also transfer the data from ABC to XYZor 2) just the DDL definitions of the tables / columns etc?If (1) then Backup ABC and restore as XYZIf (2) then either do as above and TRUNCATE / DELETE all data (there are scripts here that will help) or use SSMS to create a Script of all the objects in the ABC database, then create a new database "XYZ" and run the script to create all the objects. |
 |
|
|
|
|
|
copy database