what is the easiest way of getting database in sync
whats the easiest way of making sure that data in production database is in sync with test database hosted on the same server? Currently, my test database is not in sync with my production
database.My goal is to make sure that the data in test is up-to-date. Any suggestions? I use SQL server 2005
My first recommendation is to not have your test database on the same server as your production database. I'd recommend to get it moved off to another piece of hardware. In regards to getting it sync'd, if you don't need real-time level syncing, I'd recommend tools such as Red Gate's Data Compare or SSDT within Visual Studio. I prefer Red Gate's tool over VS, but they would both work. These would allow you to do a point in time syncing. Red-Gate:
https://msdn.microsoft.com/en-us/data/tools.aspx Will point in time syncing work for your needs or do you want it real time?