Creating SQL update scripts for the client

Question

What is the best way to support update scripts between product versions? If the client starts working with version 3 of your product and switches to version 5, then what is the way to create a script update for the client so that all differences in the database schema between versions 3 and 5 are resolved?

Answer 1

1) Use a tool like RedGate Schema and Data Compare

2) Use the Visual Studio 2008 GDR Project

3) Write your own!

Answer 2

This has been discussed many times:

How to automatically update a deployed database for end users

(SQL Server)

SQL Server 2008 (MIgrations)?

Migrator.net, -, . , , SQL , :

create table upgradetable (major int, minor int, revision int, change text)

script :

 select change from upgradetable where major > (select major from versiontable)

(, ).

, SQL, migrator.net

Answer 3

Wizardby, , . DSL , , - .

, . .

Answer 4

, , . , ETL SQL

Answer 5

, , , dbdeploy ruby. script , script, .

, , .

.

Answer 6

, .
, , , , :
. . (v3/v4).
. . ( v3 v4).
. v3 v4 v3 v5.
. .

, , .

DBSourceTools (http://dbsourcetools.codeplex.com) , , .
(v1).
- 2.
, - .

, v1 v2.
DBSourceTools , , script.

, .

.