Jeff
jeff.developer at gmail.com
Thu Jun 5 13:26:28 CDT 2014
Biggest issue is that some of the tables have been changed on the test database and I don't want to have to recreate all the changes if I don't have to. Sent from my iPhone > On Jun 5, 2014, at 11:39 AM, Francisco Tapia <fhtapia at gmail.com> wrote: > > is there any reason you don't simply just restore the backup form the live > database as a "test" database to your target server? Depending on how your > front end app works, (ie, you have an app uid ) then you'll need to migrate > the user to the test server too. > > if your test and live databases live on the same server then you can skip > the migration of users. > > -Francisco <http://twitter.com/seecoolguy> > > > > >> On Thu, Jun 5, 2014 at 8:55 AM, Jeff B <jeff.developer at gmail.com> wrote: >> >> 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 > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >