Geek asks and answers

How to import tables without losing indexes and keys in SQL Server 2008

When I use the import / export wizard, it loses keys and indexes. I need to import a lot of tables. please help.

I also created tables by creating a script and then importing, but you will find a validation error. Maybe I'm doing something wrong?

+5
source share
1 answer

First create a script to create tables, keys, indexes. If you right-click on the database, in the context menu you can click on the creation of a script in the database to invoke the wizard.

script . , , SSIS (aka DTS) , .

. FOREIGN KEYS, , SSIS !

, sql, , GO , ( ).

+4

More articles:


All Articles