Sfrgttk

Everything Bob says is false. How does he get people to trust him?

Can somebody explain Brexit in a few child-proof sentences?

How does residential electricity work?

Generic lambda vs generic function give different behaviour

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?

Go Pregnant or Go Home

Is a roofing delivery truck likely to crack my driveway slab?

How do I keep an essay about "feeling flat" from feeling flat?

The baby cries all morning

Is expanding the research of a group into machine learning as a PhD student risky?

Products and sum of cubes in Fibonacci

Teaching indefinite integrals that require special-casing

Your magic is very sketchy

Can a monster with multiattack use this ability if they are missing a limb?

Why are on-board computers allowed to change controls without notifying the pilots?

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

Is it correct to write "is not focus on"?

Is there a problem with hiding "forgot password" until it's needed?

Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?

Valid Badminton Score?

How do I define a right arrow with bar in LaTeX?

Personal Teleportation as a Weapon

What would happen if the UK refused to take part in EU Parliamentary elections?

Drop and Recreate All Objects in Database Project

DACPAC and database drift: db users are always detected as drift even when nothing has changedvisual studio database project - publish did not include drops but schema compare didBuilds and deployments to 300+ databases utilizing SSDT/VSTSWhy would I get PREEMPTIVE_OS_AUTHORIZATIONOPS using tSQLt when Working at Home?Visual Studio, GIT, and SQL ScriptsSSDT Drop and Recreate Tables when nothing has changedSQL Visual Studio Find and Replace in Publish ProfileDeploy one object in database without Whole Publish ProfileAuto Publish Deploy same table to different Schema in Database ProjectError publishing SQLCLR C# Function using Visual Studio 2017

0

I have a database project in Visual Studio Team Services Git, and want to deploy into database on actual server.

(a) Is there setting in publish profile, to drop all objects and recreate?

(b) or is there setting to create whole DDL script, rather than finding schema comparison discrepancy? Want to conduct this from Visual Studio, I know SSMS has option to Generate Scripts for all objects.

Want to conduct for all tables, sprocs, views, not just simple example below. Plan to redeploy and repopulate data warehouse everyday.

Example, say this in Source control database project.

Source Control:

create procedure dbo.SelectTestOne

as 

select 1

And actual server on localdb is

Local Server Discrepancy:

create procedure dbo.SelectTestOne

as 

select 2

Predeployment Script:

If I create a Script.PreDeployment, which drops all objects,

drop procedure dbo.SelectTest

The Final publish profile Script, will still do an alter, instead of recreate. So question is how do I drop all objects and recreate them? (I know Redgate has this option)

drop procedure dbo.SelectTest

GO



GO

PRINT N'Altering [dbo].[SelectTest]...';





GO

ALTER procedure dbo.SelectTest

as 



select 1

GO

PRINT N'Update complete.';





GO

sql-server sql-server-2016 visual-studio

share

asked 5 mins ago

GregThomas582GregThomas582

696

add a comment | 

0

I have a database project in Visual Studio Team Services Git, and want to deploy into database on actual server.

(a) Is there setting in publish profile, to drop all objects and recreate?

(b) or is there setting to create whole DDL script, rather than finding schema comparison discrepancy? Want to conduct this from Visual Studio, I know SSMS has option to Generate Scripts for all objects.

Want to conduct for all tables, sprocs, views, not just simple example below. Plan to redeploy and repopulate data warehouse everyday.

Example, say this in Source control database project.

Source Control:

create procedure dbo.SelectTestOne

as 

select 1

And actual server on localdb is

Local Server Discrepancy:

create procedure dbo.SelectTestOne

as 

select 2

Predeployment Script:

If I create a Script.PreDeployment, which drops all objects,

drop procedure dbo.SelectTest

The Final publish profile Script, will still do an alter, instead of recreate. So question is how do I drop all objects and recreate them? (I know Redgate has this option)

drop procedure dbo.SelectTest

GO



GO

PRINT N'Altering [dbo].[SelectTest]...';





GO

ALTER procedure dbo.SelectTest

as 



select 1

GO

PRINT N'Update complete.';





GO

sql-server sql-server-2016 visual-studio

share

asked 5 mins ago

GregThomas582GregThomas582

696

add a comment | 

I have a database project in Visual Studio Team Services Git, and want to deploy into database on actual server.

(a) Is there setting in publish profile, to drop all objects and recreate?

(b) or is there setting to create whole DDL script, rather than finding schema comparison discrepancy? Want to conduct this from Visual Studio, I know SSMS has option to Generate Scripts for all objects.

Want to conduct for all tables, sprocs, views, not just simple example below. Plan to redeploy and repopulate data warehouse everyday.

Example, say this in Source control database project.

Source Control:

create procedure dbo.SelectTestOne

as 

select 1

And actual server on localdb is

Local Server Discrepancy:

create procedure dbo.SelectTestOne

as 

select 2

Predeployment Script:

If I create a Script.PreDeployment, which drops all objects,

drop procedure dbo.SelectTest

The Final publish profile Script, will still do an alter, instead of recreate. So question is how do I drop all objects and recreate them? (I know Redgate has this option)

drop procedure dbo.SelectTest

GO



GO

PRINT N'Altering [dbo].[SelectTest]...';





GO

ALTER procedure dbo.SelectTest

as 



select 1

GO

PRINT N'Update complete.';





GO

sql-server sql-server-2016 visual-studio

share

asked 5 mins ago

GregThomas582GregThomas582

696

create procedure dbo.SelectTestOne

as 

select 1

create procedure dbo.SelectTestOne

as 

select 2

drop procedure dbo.SelectTest

drop procedure dbo.SelectTest

GO



GO

PRINT N'Altering [dbo].[SelectTest]...';





GO

ALTER procedure dbo.SelectTest

as 



select 1

GO

PRINT N'Update complete.';





GO

share

asked 5 mins ago

GregThomas582GregThomas582

696

share

asked 5 mins ago

GregThomas582GregThomas582

696

asked 5 mins ago

GregThomas582GregThomas582

696

asked 5 mins ago

GregThomas582GregThomas582

696