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 |
|
Richard Steele
Starting Member
11 Posts |
 Posted - 2002-09-27 : 19:58:21
|
| If I don't have permission to copy my entire remote database, how do I export an exact copy of all of the tables from within such database? My experience with DTS has been that choosing copy tables and views from the source database will drop some of the settings. I then have to painstakingly recreate this information. I've heard that creating a script to do this may be the solution, but I don't have any experience in doing this. Is there a FAQ sheet or SQL help that will give me clues? Thanks in advance. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-29 : 04:19:23
|
| Well, you can select "copy objects and data" in DTS, and that will actually allow you to export exact replicas of your tables (Including indexes, constraints etc..).Or scripting will work. In em, select a table, right click, select all tasks, and select generate script. This brings up a wizard that is pretty intuitive.-Chad |
 |
|
|
|
|
|
Exporting Exact Copy of Database Tables