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 |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2010-03-22 : 08:18:38
|
| HiI am trying to copy from sql_server1 db MRT_FIN databse table structur into sql_server2 MRT_FIN1 database whic i created in the new server.what i am trying is i want to get a copy of all the tables in database MRT_FIN in sql_server1 into MRT_FIN1 in another sql_server2.the size is not enough in sql_server2 is there any option to minimize the data in sql_server1 before copying into sql_server2 MRT_FIN1 database.could anyone help me in doing this plz.thanxyashuyashu |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-22 : 08:31:00
|
| Create a script of all the DDL on Database1 (which will not include any data) and then run that script on Database2 - which will create an empty database.If you then need to copy some data across you can use SSIS to do that - choose which tables, and just the data for those tables will be copied over. |
 |
|
|
|
|
|
How to copy tabledata structurein SQL2005