March 27, 2003 at 10:34 pm
Is there a way I can import MSAccess table indexes and Primary Keys when I import the tables into MSSQLServer 2000 using the DTS???
If not it's going to be a long day Monday.
Bruce
March 28, 2003 at 8:38 am
You can create linked server to your Access database and use "sp_indexes" to list indexes information from ACCESS database into a temp table and write TSQL script to loop this temp table to construct SQL statements to create indexes in SQL Server tables.
The indexes migrated from Access to SQL Server may not work perfectly in SQL Server and you need to monitor the application performance with Profiler and re-adjust the indexes. Index wizard is one of the tools you could use.
Edited by - Allen_Cui on 03/28/2003 09:36:53 AM
March 29, 2003 at 4:03 pm
Thanks
I'll do that Monday. After posting the questions Friday I had some success exporting one table at a time using the upsizing wizard in Access.
Bruce
March 29, 2003 at 6:19 pm
Could also do it the other way around, write some Access code to loop through your objects to generate the code to create the indexes. Don't know that one way is better than the other.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply