Export both data and table schema | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export both data and table schema

I still can’t find a feature in SQL 2K5 that will allow me to transfer both data and table schema (i.e. table definition, indexes, primary key, trigger, etc) in a single process, which I can do in SQL 2K. Can someone point me to the right place? wingman
I believe that feature is missing in sql server 2005…
Check the following article which explains it… SQL Server 2005 Integration Services – Import and Export Wizard
http://www.databasejournal.com/features/mssql/article.php/3594201
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Data using SSIS and schema (table structure) using Scripting wizard can accomplish the task, but not in one shot though. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Microsoft did not keep one shot option…<br />May be in next release or build [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
Not at all, I guess as it is available through other options it will not be. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>