We are moving our Access MDB (2003 format) to SQL server. Every table in the Access DB has a unique primary key/index defined and most have several other indexes also.
I used the SQL Import Wizard to create a SQL DB with all of the Access tables. It went very smoothly and all tables were imported.
When I look at the tables in SQL Management studio none of them have any indexes, or a primary key defined.
Is this the way they are always imported or did I miss an option on the import to pull the indexes into SQL with the tables?
Is it possible to pull the indexes with the tables using the Import wizard?