Database updates via SQL scripts


We have a client that has their own dev server in addition to a local dev server that we have and control.  Each parties already have a copy of the code and database with the site running.  The client requested that future database change releases needs to be delivered in SQL scripts instead of database backups.  We are not sure how to proceed or even know if it is possible since the each release will probably also affect the database schema.  My best guess is to use a comparison tool like SQL Compare and manually script the changes from the old and new database.  I realize this also can be dangerous and will most likely break some things.  Can anyone share any light on this?

Jul 05, 2011 23:35

Are you changing much on the database outside of added pagetypes?

Jul 06, 2011 0:20

Once in a while, the database will be changed outside of added pagetypes.  For now, our client decided to use the import/export method of adding new pages.  We may not have to rely on SQL scripts anymore.

Jul 12, 2011 16:25
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.