Posts
Sort by recent activity
Preventing SQL Compare from DROP and CREATE SYNONYM
Hey all,We have a reporting database where on the live server we point our synonyms at [Production].[dbo].[tblName], but on our replicated server we use [Reports].[Production].[tblName].When I try ...
Comparing to ALTER scripts instead of CREATE
Hey guys,All of our scripts in source control follow a pattern like this:
IF ISNULL(OBJECT_ID('dbo.vwView'),0) = 0 EXEC ('CREATE VIEW dbo.vwView AS SELECT 1 fldDummy')
GOSET QUOTED_IDENTIFIER ONSE...
Comparing a db to a Scripts folder - can I exclude a subfolder?
I'm trying to run an SQL Compare against a folder we've had source controlled for years, and I am getting errors because under the structure we have a "Replication" folder. This contains some dupl...