Red Gate forums :: View topic - Migrating data between dev database and live database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Migrating data between dev database and live database

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
shat



Joined: 25 Mar 2013
Posts: 1
Location: Tulsa, Oklahoma

PostPosted: Mon Mar 25, 2013 5:39 pm    Post subject: Migrating data between dev database and live database Reply with quote

I currently have two database servers, production and development.

The development database server has a specific database that I modify both schema design (for tables) as well as some data.

I would like to compare the data between the two tables, between the two servers as well as any design differences.

Is it possible to do so with SQL Data Compare or SQL Compare? I have the developers bundle and license.

There are only a few new rows that I know I need to copy from development -> production.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Tue Mar 26, 2013 11:42 am    Post subject: Reply with quote

Hi shat,
thank you for your forum post.

In the scenario you have described in your post, you will need to use SQL Compare and SQL Data Compare. Unfortunately there is not a single tool that does both.

Using SQL Compare will you be able to compare and deploy any design differences. Followed by SQL Data Compare to compare, select the required rows of data and deploy the selected data between the development and production databases.

Further help on using SQL Compare and SQL Data Compare can be found in the help articles on following web pages:

SQL Compare - http://www.red-gate.com/supportcenter/Product?p=SQL%20Compare

SQL Data Compare - http://www.red-gate.com/supportcenter/Product?p=SQL%20Data%20Compare

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group