Posts
Sort by recent activity
GO not being indented properly
USE master;
GO
SELECT *
FROM dbo.spt_values;
GO
If I run the Format SQL command I would expect that the GO lines would be aligned with the USE and SELECT statement lines respectively; ho...
Automap "feature"
Is there a way to disable the auto-map feature in the options or alternatively on the specific tables in the table comparison dialog? I have a lot of tables where the column names differ just on th...
Deployment script creation progress
12.0.26:
Creating a deployment script covering around 3.5M records across 20+ tables. The deployment screen displays a "Deployment (Not Responding)" in the upper left title sectiona nd ultimately c...
Including WHERE clause in deployment script
v12.0.25.3064:
When comparing tables utilizing a WHERE clause to restrict the datasets to be compared and then subsequently generating the deployment code the code will include the WHERE clause fro...
Data compare displaying incorrect info
v12.0.25.3064:
Comparing two table on INT primary key, tow other columns are VARCHAR. Option force binary collation enabled. Rows in source and destination are differrent due to different capitaliz...
UX Issue: Spelling mistake
Under "Options" the entry "Don't use transactions in the deploymnet script" has "deployment" misspelled
BUG: SQL authentication failure
v12.0.24.3012 Professional:
Source database uses Windows authentication, target database uses SQL Server authentication. As soon as I select an existing project I am receiving notifications from SQ...
Formatting bug
ORDER BY statements after a HAVING clause do not receive their aliases.
Repo:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Project_Express_MR53_stg] ([D...
Verify backup files
I know that I can verify backup files while the backup itself is running. However, I'm trying to shorten my backup window and would like to run the verify option separately against the backup files...
Formatting bug in 6.4.0.659
Index formatting adds the table name prior to the index name, resulting in a syntax error in SQL Server 2008 R2
Repo:
-- execute first two statements
CREATE TABLE repo (id INT IDENTITY(1, 1)
...