Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Customer installer

David Hait Nov 21, 2013 08:03AM AEDT

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?

Up -15 rated Down
Daniel Nolan Nov 22, 2013 12:10AM AEDT ReadyRoll Agent

Hi David,

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.

Regards,

Daniel

This question has received the maximum number of answers.

readyroll.support@red-gate.com
http://assets0.desk.com/
false
readyrollsql
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete