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 |
|
multiplex77
Starting Member
24 Posts |
 Posted - 2006-10-24 : 01:52:59
|
| Hi all,Is there a way to use the Export function in SQL Server Management Studio (2005) to export not just table data, but the whole table object? It could be done in SQL Enterprise Manager.My reason for doing this is I want to export my tables AND their primary keys and identity columns from my local development machine to a remote server. CUrrently when I use the "Export data" function, it only exports the data and not the PK and Identities. Or is there a "more correct" way of accomplishing this?Any advice would be appreciated. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-24 : 23:40:55
|
| you can generate the table script and associated objects (under the options tab) from ssis not EM, try to search also for some scripts you can run in QA from www.mindsdoor.netHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Copying table objects in MSSQL 2005 Mgt Studio