Red Gate forums :: View topic - How to compare individual objects?
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

How to compare individual objects?

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



Joined: 12 Feb 2010
Posts: 3

PostPosted: Fri Feb 12, 2010 11:29 pm    Post subject: How to compare individual objects? Reply with quote

Where I currently work as a developer, it is my role to create stored procs necessary for my projects; however, when it comes to deployment it is up to our DBA's to deploy the stored procs accross our multiple databases. Unfortunately the DBA's do not use RedGate tools to help with this and do it manually and sometimes they forget to deploy to some databases.

I'm trying to figure out a way that I can create a list of database objects that I have either created or modified for my projects and then take a snapshot of my database that I know is accurate and then compare just those individual objects to the production databases to make sure things got deployed correctly. Or possibly use the script files instead of a snapshot of the database.

So far I haven't found a way to compare individual objects. The only thing I've been able to do is use CompareWith and get all the differences and then loop through them looking at the names for the specific ones I'm interested. Is this the best way?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Sun Feb 14, 2010 1:12 am    Post subject: Reply with quote

Hi Anthony,

The SDK works like the commercial version of SQL Compare. You must compare everything, then filter out objects that you do not want to synchronize. Once the comparison completes, the collection of differences can be enumerated and examined using code. That's the only way that it works.
Back to top
View user's profile Send private message
acaterino



Joined: 12 Feb 2010
Posts: 3

PostPosted: Sun Feb 14, 2010 11:43 pm    Post subject: Reply with quote

Thank you for the response. That's what I assumed, but wanted to make sure I wasn't missing anything.
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