Posts
Sort by recent activity
Azure Shadow DB not getting drop
Hi
I am using SQL Change Automation in
Visual Studio, Facing an issue, whenever i click on Refresh button ( for
refreshing list of database object changes pending import in SCA window ) a
sh...
sequence of script execution
Hi
I am using SQL Change Automation in
Visual Studio, Facing an issue with sequence of script execution.
Here is what i am doing
1) Add a Stored Procedure ( let’s
say addValue) in Source databas...
Generate CREATE + ALTER Stored Procedure Script
HiBy default, SCA generated the Stored Procedure Script as DROP + CREATE IF OBJECT_ID('[dbo].[My_SP]') IS NOT NULLDROP PROCEDURE [dbo].[My_SP];GOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOCREATE...
Generate CREATE ALTER Procedure Script, not DROP CREATE
Hi,By default, when generating baseline script, all the Stored Procedures are scripted as DROP and CREATE<br><div>IF OBJECT_ID('[dbo].[My_SP]') IS NOT NULL</div><div> DROP PROCEDURE [dbo].[My_SP];<...
The database snapshot was saved by a newer version of SQL Compare
HiWe are using RG Azure DevOps extension ( build and Release) to do the deployments to SQL Server.Everything was working well, but suddenly today start getting deployment error as "The database sna...
How to set "baseline your incremental migrations" in Project Settings.
Hi I have below scenario.Having existing Production Database as well as Development Database.Created SCA Project, by setting "Production Database" as Target Database and "Development Database" as "...
Input DB to create SCA Project
HiWant to understand the best recommendation for Source DB to create a SCA Project, I mean what should i consider a Dev database or Prod Database, and why?ThanksGill
Any way to Include table data without setting Primary Key
I have an existing table without primary key, which is having data. I want to include this data as part of migration script. Is there any way to do so?I know i can consider Bulk Insert or Merge, bu...