Is there a way that a ReadyRoll deployment can be packaged up and sent to a customer for them to deploy on their own database server?
ReadyRoll can produce a package in SQLCMD format which can be used to distribute your database.
When the package is executed on your customer’s server, which can be done through SSMS or via the SQL Command Line Utility (SQLCMD.EXE), it will create the database from scratch if it doesn’t exist, or it will apply any pending migrations if it does already exist.
To generate a package as part of your build, open the project properties to the Project Settings tab and select “SQLCMD package (.sql)”. When you build you’ll notice apart from the “DatabaseName_Package.sql” file, there is a .cmd file as well which provides an example SQLCMD calling syntax.
If you need a one-click type of deployment package for the customer, you could wrap this in an installer like WiX and bootstrap SQLCMD with it.
This question has received the maximum number of answers.