ndb.exe is a migration tool for Sql Server. Well fit small developmemt team. Integrated with Sql Server Management Studio and Source control. The XML output allows to integrate with Continues Integration tools such as Cruise Control.NET
- http://go.microsoft.com/fwlink/?LinkId=123721&clcid=0x409
- http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409
- http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409
- ndb.exe /reset or /r [Clear and recreates the database for the current /environment]
- ndb.exe /version or /v [Retrieves the current schema version number]
- ndb.exe /clear or /cl [Clears all the local databases defined in ndb.exe.config]
- ndb.exe /create or /cr [Create the database defined in ndb.exe.config for the current /environment]
- ndb.exe /migrate or /m [Migrate Database]
- ndb.exe /migrate_to or /mt [Migrate database to version. e.g. /mt:10]
- ndb.exe /no_aspnet_membership or /no_aspnet [Ignore install ASP.NET Membership Database (default no_aspnet)]
- ndb.exe /aspnet_membership or /aspnet [Install ASP.NET Membership Database]
- ndb.exe /trace or /t [Turn on invoke/execute tracing, enable full backtrace.]
- ndb.exe /environment:{Development, Production} or /env [Specify the environment to run script.]
- ndb.exe /xml or /xml [Xml output e.g. /xml:C:\temp\out.xml.]
- ndb.exe /fixture or /f [Include fixture data in \fixtures folder.]
- ndb.exe /grant_permission or /grant [Specify the user to grant permission to access database. e.g. /grant:"NT AUTHORITY\NETWORK SERVICE"] ndb.exe /help or /? [show help]