Post reply

sqlpackage is not generating full deployment script

  • December 9, 2015 at 5:17 pm

    #313885

    Hello,

    I'm currently using vsdbcmd to create a full deployment script off of my Visual Studio database projects that creates a new database and all its objects.

    I don't need incremental script. Also, I need the script without specifying Target Server name, which I wouldn't know at the time of generation. Later our install team will take the script and run it on a server that will create a new database.

    I tried various options to do the same with sqlpackage.exe. But none produced the same results that vsdbcmd offered.

    Please let me know how to get the full deployment script (with Create Database) using sqlpackage.exe without specifying TargetServer name.

    Thanks,

    Raj

  • December 14, 2015 at 10:14 am

    #1845870

    Did I post in the wrong forum? Please advise.

    Thanks,

    Raj

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply