From SQL Server 2000 Import wizard, if we use Copy Objects & data between SQL Server Databases it'll copies table with primary key. Similar to this what is the alternative method in SQL Server 2005.
Please suggest me to solve the problem
Thanks in advance
Karna
You still have the Import/Export wizard in SQL Server 2005 but you would need to have SQL Server Management Studio not the express version.
Right click on a database and choose tasks-> export data
which then lets you copy tables.
I hope that is what you are looking for.
|||Hi,Thanks for reply,
As u said it is similar to Import/Export wizard that we found in SQL server 2005 Management studio, here in this example it does the export of table to the destination database but primary key will not be attached. Is it SSIS is helpful for this purpose.
My problem is when I export table to different database it should export all attributes of table which includes Primary Key (as similar to copy objects & data between SQL Server Databases in SQL Server 2000).
Please suggest me to solve my problem
Thanks in advance
Karna|||
Have you looked at the Copy Objects task available in the SSIS designer?
Thanks.
|||Hi,Thanks for the reply.
It is same as I briefed in earlier mail.
My problem is when I import table from one database to another it has to import data with primary key constraints.
Thanks in advance
Karna
