Jim Lawrence
accessd at shaw.ca
Thu Jun 5 14:16:00 CDT 2014
Hi Jeff: Have all the keys fields been removed from the destination table? That is the best way to do it even if the receiving key fields are not automated. If a destination table is full of indexes, the appending process will be excruciatingly slow as the receiving table has to re-index after every new record. MS SQL 101. Jim ----- Original Message ----- From: "Jeff B" <jeff.developer at gmail.com> To: "Dba-SQL" <dba-sqlserver at databaseadvisors.com> Sent: Thursday, June 5, 2014 8:55:54 AM Subject: [dba-SQLServer] Appending Data with AutoNumber in SQL Server I am going to post this in the Access group as well, as a separate email. I am trying to use MS Access queries to append data from a table in one SQL database into a table in a second SQL database. The first contains live data that needs to be moved to a test database. I have deleted all of the data from the tables in the second database, and have reset the auto number (or identity in SQL) back to 0. However, when I try and use an Access append query, it fails and tells me there are key violations. I thought that be deleting all data and reseeding the identity, I would avoid these problems. Anyone know what I need to do in order to make this work? Jeff Barrows MCP, MCAD, MCSD Racine, WI jeff.developer at gmail.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com