Synchronize Database Against Script(s)

cnotley

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

James B

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!