SQL Server Performance

Identity column not retaing during database import

Discussion in 'SQL Server 2008 General DBA Questions' started by cijojohn, Jul 13, 2009.

  1. cijojohn New Member

    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.
  2. satya Moderator

    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?

Share This Page