Red Gate forums :: View topic - Static Data - Synced by SQL Compare or Data Compare?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Static Data - Synced by SQL Compare or Data Compare?

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Thu Nov 24, 2011 12:04 pm    Post subject: Static Data - Synced by SQL Compare or Data Compare? Reply with quote

Newbie Question on Static Data

This may sound like a very obvious quesion but I thought I knew the answer and now I am not so confident!

I have set-up a number of tables as Static Data within SSC. Commiting changes finds these and commits them. All Good.

When use SQL Compare to release my changes to my live database, is it SQL Compare that will update my live server with this new static data, whilst also making any database changes, or do I also have to use Data Compare to sync the new static data to live?

I was under the impression static data was handled by SQL Compare but as I am using SQL Compare this does not appear to be the case.

Could someone please confirm what I'm thinking. And if I do need to use Data Compare to release my static data changes to live, is there any way when using comparing two databases, to only look for changes to static data?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Nov 28, 2011 1:18 pm    Post subject: Reply with quote

Hi, and thanks for your post.

SQL Compare will only compare and synchronize schema differences (think new tables, changes to stored procedures etc).

Any data records you want to sync between databases will require the use of SQL Data Compare. SQL Compare doesn't perform any operations on the actual data at all.

Hope that helps!
Back to top
View user's profile Send private message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Mon Nov 28, 2011 2:47 pm    Post subject: Reply with quote

Thanks for your reply.

In that case, is there any way to configure SQL Data Compare to be able to only check for changes in static data?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Nov 28, 2011 2:54 pm    Post subject: Reply with quote

When you run Data Compare it will list all the differences it finds- these are of 3 possible types:

- existing only in the source
- existing only in the target
- existing in both, but differing.

You can choose which ones you want to sync. There's a good Getting Started guide here
Back to top
View user's profile Send private message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Mon Nov 28, 2011 2:58 pm    Post subject: Reply with quote

I am aware that it is possible to only sync certain tables but is it possible to set Data to only compare certain tables during the compare?

Running a Data Compare between our development database and live server takes approximately 30 minutes when we are only actually interested in changes between tables we have flagged as static. If it was possible to only compare these static tables (approximately 15-20 tables), the compare would be much quicker.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Nov 28, 2011 3:03 pm    Post subject: Reply with quote

Yes, in the GUI you can just select the tables you want to compare on the "Tables & Views" tab. If you save this to a Project File, you can also use this in the commandline with the /Project switch.
Back to top
View user's profile Send private message
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