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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-03-27 : 23:02:40
|
| HiI would like to export db tables to another server. I have try to use export feature but it will not exporting index triggers, constraint, etc. Is there any efficient way to export table data as well as other info? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-27 : 23:11:27
|
| Short of backing up and restoring the DB to the target server, you need to generate the scripts for your indexes,constraints/triggers/Fkeys and compile them on the target server. If you need *everything* then you can backup the db and restore on the target server, with a different name for the DB if its on the same server.************************Life is short. Enjoy it.************************ |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-03-27 : 23:23:25
|
| Hi dinaka,Thanks for the reply.I try to export some tables from production to development server. I acutally cannot simply use backup and restore becasue there are some extra tables or SP I want to keep there. I can create scripts for index, constraints in each table. but it takes too much time to check and scripts. Is there other way to do it?cheers |
|
|
|
|
|
|
export db tables