InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 06:02:10 GMT20http://www.sqlservercentral.com/Forums/Topic1408997-392-1.aspxNo, you should not have to; the db engine takes care of that itself.From Books Online:"If the value inserted is larger than the current identity value for the table, SQL Server automatically uses the new inserted value as the current identity value."So, SQL Server auto-adjusts the identity value up as you add higher-valued rows.Mon, 21 Jan 2013 14:24:37 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1408997-392-1.aspxHow do you copy the data?With BCP OUT you can dump all tables into files (use -N option to convert all textual fields to unicode while keeping other fields native), and then bulk-load them with BCP IN.Speed i get on my laptop is about 200 000 rows per second for both directions.BCP also has -E option to preserve identity value: kind of automatic set identity insert on ... off for you.HTH,VedranSat, 19 Jan 2013 19:44:25 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1408997-392-1.aspxNo. This is incredibly easy to evaluate. Create a table and try it out.[code]create table IdTest( MyId int identity not null, SomeValue varchar(10))insert IdTest select 'Row 1'SET IDENTITY_INSERT IdTest oninsert IdTest(MyId, SomeValue)select 2, 'New Value'SET IDENTITY_INSERT IdTest offinsert IdTestselect 'Final Test'Select * from IdTestdrop table IdTest[/code]Now unless your identity column is a primary key or has a unique index there is nothing to prevent duplicates.You can read about the Set IDENTITY_INSERT on BOL. [url=http://msdn.microsoft.com/en-us/library/ms188059.aspx]http://msdn.microsoft.com/en-us/library/ms188059.aspx[/url]Fri, 18 Jan 2013 10:09:01 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1408997-392-1.aspxI'm doing unicode conversion. I am recreating a mirror image of some 100 databases and all their objects. Before I create the objects, I am changing from varchar to nchar etc. Then I do the copy from the old to new unicode database. If I do an insert with identity insert on and then turn it off, do I need to do a reseed the identities?Fri, 18 Jan 2013 10:02:24 GMTSailor