资 源 简 介
db-advance is a tool to deploy changes to SQL Server database.
db-advance works with package which is a simple zip file with contents of following structure:
+---0001| +---Commit| | 001.schema.sql| | 002.data_TestTable.sql| | 003.sp_GetDataFromTestTable.sql| || ---Rollback| 999.schema.sql|+---0002| +---Commit| | 001.schema.sql| || ---Rollback| 999.schema.sql|+---0003| +---Commit| | 001.schema.sql| || ---Rollback| 999.schema.sql|---0004 +---Commit | 001.schema.sql | ---Rollback 999.schema.sql
Each folder represents delta with two parts - commit and rollback. Scripts in folder are executed sequentially in alphanumeric order.
Command line to deploy database:
DbAdvance.Host.exe -commit "Data Source=(local);User Id=sa; Password=god" DatabaseName buildsuild.zip
It will apply all delta
文 件 列 表
db-advance
DbAdvance.Host.exe
DbAdvance.Host.exe.config
ICSharpCode.SharpZipLib.dll
Microsoft.Practices.ServiceLocation.dll
Microsoft.Practices.ServiceLocation.xml
Microsoft.Practices.Unity.Configuration.dll
Microsoft.Practices.Unity.Configuration.xml
Microsoft.Practices.Unity.dll
Microsoft.Practices.Unity.Interception.Configuration.dll
Microsoft.Practices.Unity.Interception.Configuration.xml
Microsoft.Practices.Unity.Interception.dll
Microsoft.Practices.Unity.Interception.xml
Microsoft.Practices.Unity.xml
UnityConfiguration.dll
UnityConfiguration.xml