I’m using SQL server 2008 to import a database from a different server. both the servers are sql server 2008Some of my source tables have identity column. During import the identity columns are not getting created as identity in my destination database.The column looses the identity property. i'm also loosing the primary key properties during import. I created a fresh database and try to import by giving the option create tables in the sql server import wizard. it did'nt work.How can I retain the identity columns and primary keys during import?Any help is appreciated.
Welcome to the forums. Are you restoring the database between the servers or importing the data using SSIS or import/export wizard? Have you treid to recreate the tables using the scripting method from source server?