Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL2K -> SQL05 import index??
Message
 
 
To
06/06/2007 13:15:01
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01231027
Message ID:
01231626
Views:
10
>I have been working with the import wizard in SQL 05, pulling data from SQL 2K. The data comes across, but the primary key and index definitions are not there. Am I missing something??
>

The SQL Server Import Wizard main purpose is to copy data from a source to a destination. It's up to you to make sure that table definitions, including indexes, FK, CK, etc., on the destination are correct.
You may want to use the Copy Database Wizard instead if you're transfering whole DB.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform