Synchronize Database Against Script(s)

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Synchronize Database Against Script(s)

Postby cnotley » Tue Jul 06, 2010 6:17 pm

I want to build a simple executable for our users that includes a SQL script representing the schema of our database. The executable would be run by the users against their database, which is an older version of our database. The executable would essentially synchronize the schema of their database with the schema specified in the script(s).

From what I have read, this appears to be possible, but any guidance on where I might read documentation on how to do this specifically would be appreciated.

Thanks.

Chris
cnotley
 
Posts: 1
Joined: Tue Jul 06, 2010 6:13 pm

Postby james.billings » Wed Jul 07, 2010 7:26 pm

This sounds like an ideal scenario for SQL Packager, and we have a walkthough of a database upgrade available on the website. Please follow this link to find it: http://www.red-gate.com/products/sql_packager/walkthrough1/step1.htm

Hope that helps!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests