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.