Import and Export Wizard with Identity Column

sql-server sql-server-2008 sql-server-2008-r2
Elad Lachmi picture Elad Lachmi · May 5, 2011 · Viewed 60.5k times · Source

I want to move data from one DB to another, while keeping the identity column values in the old DB. When I run the wizard I get a validation error "Failure inserting into the read-only column "ChannelID".

Where ChannelID is an identity column on that table. How can I override the identity functionality in order to be able to import the data?

Answer

MichaelHouse picture MichaelHouse · May 5, 2011

You'll need to Enable identity insert. There's a check box when you click the Edit Mappings.

Related questions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More
Using IF ELSE statement based on Count to execute different Insert statements

While I am searching through my database, I run an INSERT statement if I find that a particular item does not exist, and I run a different INSERT statement if I find one or more of this item. I am …

Read More