How to create a pre-packaged deployment script for a database project?

Question

I have a DB project in Visual Studio and I need to deploy it to a remote system as a pre-packaged script (or similar) as a new database.

The Publish option will generate a .publish SQL script but only if you supply a connection first, and the script includes machine-local information e.g. logging paths.

I want something I can copy onto the DB-server machine running SSMS and it will create the DB. What is the proper way to do this, I see I also have DAC and DLL files emitted during build.

David Browne - Microsoft · Accepted Answer · 2022-01-20 15:09:58Z

1

What is the proper way to do this?

Connect to a server that doesn't have any version of your database, and publish. Publish calculates an incremental deployment, so it needs to see the current state of the target SQL Server.

answered Jan 20, 2022 at 15:09

David Browne - Microsoft

90.8k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mr. Boy Over a year ago

I cannot connect to the server. I need to produce something I can transfer to a separate system. It doesn't have to be SQL scripts but that's all I'm familiar with. Is that what all this DAC/DLLs are for?

David Browne - Microsoft Over a year ago

Publish to a local SQL Server to generate the script.

Mr. Boy Over a year ago

Sorry I misread you there that makes more sense.

Collectives™ on Stack Overflow

How to create a pre-packaged deployment script for a database project?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related