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?
A:
You will have to go for "Transfer SQL Server objects" in SSIS.
Here's a simple illustration to accomplish what you need.
bioskope
2009-04-16 05:24:32
Not simple enough, I cannot penetrate the jargon in the opening sentence. ssis is not available via ssms, but I know I have run it before. How do you run ssis? It's not in the start menu or in ssms.
P a u l
2009-04-16 06:57:32
Start Menu >> Microsoft SQL Server >> SQL Server Business Intelligence Development Studio (BIDS). In BIDS . New >> Project >> Templates >> Integration Services Project
bioskope
2009-04-16 13:48:45