We help IT Professionals succeed at work.

Keep Production Data in SYNC with DEV Database???

Last Modified: 2008-02-19

Is there a clean way to keep my dev database in sync with my production database?  So if a user saves a record in production, this information gets populated to our dev database?  It does not have to be real-time, but that would be nice.  I am using SQL 2005.

How can I do this?  Replication?  If so how, I am not familiar with replication

Watch Question

Replication is pretty easy, but is this a database you have created. When using replication the tables are modified to help keep the information updated, and sometims this can cause havoc in an application. But if you created the database, you should be fine since you can rewrite any queries if needed.

The steps for creating the replication are within SQL 2005 itself, and step by step. I have actually set this up using a POS system, every time a transaction was created it was instantly replicated to the backup db.
Just open SQL Server studio and search help for replication. I tiny bit of reading and you will understand it quite easily.

Hope that helps, I would go into detail, but I think it would be redundant, all the info you need is right there.
This one is on us!
(Get your first solution completely free - no credit card required)



Is database mirror more for having high availability on production machines for example?  It seems while it *could* work and most likely does work the intention is a bit different.  I don't think I need something real time, but a nightly job would be fine.  How could I do this?

Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.