I'm importing data from one SQLServer2005 instance to another using the Import wizard and getting the importer to drop/create the tables for me. This runs great but on the new server, the tables are created without PK's, FK's or indexes. Is there some option I can set in the importer to do this for me?
If not, is there some simple way to 'import' those definitions after the importer has run and created my tables and populated them?
Thanks!