Red Gate forums :: View topic - Can snapshots contain data?
Return to www.red-gate.com RSS Feed Available

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

Can snapshots contain data?

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
j



Joined: 12 Mar 2009
Posts: 5

PostPosted: Fri Mar 13, 2009 10:40 pm    Post subject: Can snapshots contain data? Reply with quote

I've had success so far with the Compare engine, but not the DataCompare engine.

When I try to programmatically take a snapshot of a database that has data by RegisterForDataCompare() and then SaveToFolder(), only the schema scripts are created, no inserts.

What step am I missing?

Thanks,

J
Back to top
View user's profile Send private message
simon.jackson



Joined: 08 Jan 2009
Posts: 45

PostPosted: Mon Mar 16, 2009 10:46 am    Post subject: Reply with quote

Snapshots can currently only contain schema information. You can use the compare to backup functionality of Data Compare to get similar behavior with data.
Back to top
View user's profile Send private message
j



Joined: 12 Mar 2009
Posts: 5

PostPosted: Mon Mar 16, 2009 5:28 pm    Post subject: Reply with quote

Thanks for your response.

So is there no easy way to do a datacompare with a source other than a real database?

I think a redgate backup could do this, but that seems like too complex a set of products for this project at least.

So is the recommended way to go to use the schema-only update as I already have working, and then augment that with an independent, hand-crafted script that ensures that the necessary data values are present in the few lookup tables?

Thanks,

J
Back to top
View user's profile Send private message
simon.jackson



Joined: 08 Jan 2009
Posts: 45

PostPosted: Mon Mar 16, 2009 5:33 pm    Post subject: Reply with quote

You can datacompare with a backup file, either a native one made with SQL Server or one made with Red Gate SQL Backup.

The currently supported way of combining data and schema is
- Compare with a SQL Compare snapshot or scripts folder in order to update the schema
then
- Date Compare with a SQL Server/Red Gate SQL Backup backup file in order to change the values in lookup tables etc.

This combination should allow you to create the scripts dynamically.
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