asked on

Keep Production Data in SYNC with DEV Database???

Hi,

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

-ws

mdefalco

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.

ASKER CERTIFIED SOLUTION

Wizilling

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Westside2004

ASKER

Hi,

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?

-ws