sql server: import operation won't copy full schema
- by P a u l
I recall that the import tool in sql server 2000 would copy indexes, relationships, etc.
In sql server 2005/2008 the import tool in SSMS will only create the tables, copy the data, but the keys, indexes, relationships are missing. I can find no option in the import wizard to enable this? What am I missing here? Is this not possible anymore for any good reason?