Version control of data

msollicitomsollicito Posts: 7
I am trying to decide the best way to version control the DATA in our databases. However, the primary keys / foreign keys will be different in our Staging Database to our Production Database, but I am assuming that is pretty common?

Can SQL DATA Compare handle that? I want to be able to select which data in the Staging database should be copied to Production, but in Production the keys will be different to those in Staging (auto generated identity type keys) because we have some test ids in Staging, etc.

That should work fine in SQL DATA Compare right?
Contact me on:
Email /Yahoo! Messenger michelle.sollicito@yahoo.com
GoogleTalk/MSN michelle.sollicito@gmail.com

Comments

Sign In or Register to comment.