Import Table Full into sql server 2005

[Ingemark71]

Hi,
How to import any table from db A into db B in SQLServer 2005 with Microsoft sql server Management Studio?
I mast import Data,field,index,extend properties, FK primary key,Identity.

Marco

 

[mrdenny]

You can't. The import wizzard will import the data and the basic table structor. indexes, extended properties, relationships will need to be manually recreated.

You may want to take a look at the database upsizing wizzard. It may handle more than just the data.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com