Activity overview
Latest activity by cardsharp
Well, my database is 150 GB. I guess I could create an empty copy of it...
As for checking for quotes in the DB, I've checked the original DB and it does have brackets. Not sure why the snapshot thinks it's supposed to be quotes.
In MSSMS I click "Script Stored Procedure" and script it to a file, I get a create statement that looks like:
USE [warehouse]
GO
/****** Object: StoredProcedure [dbo].[BillingReport] Script Date: 08/15/2007 09:36:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[BillingReport] (@OrgObjectId INT, @beginDateTime DATETIME, @endDateTime DATETIME)
...
But when I compare it with SQL Compare, It shows quotes: CREATE PROC "dbo"."BillingReport" (@OrgObjectId INT, @beginDateTime DATETIME, @endDateTime DATETIME)
...
/ comments
Well, my database is 150 GB. I guess I could create an empty copy of it...
As for checking for quotes in the DB, I've checked the original DB and it does have brackets. Not sure why the snapshot ...
Brackets vs. Quotes in Snapshot Comparison
I've used SQL Compare 6 to generate a snapshot. When I compare the snapshot with another copy of the database it wants to rename every single stored proc in my DB using quotes rather than brackets...
Index Creation Order
SQL Compare Version: 5.3.0.44
I've noticed that SQL Compare generates scripts that create indexes in a sub-optimal order. In the scripts it first creates unclustered indexes, and finishes up with ...