What are the challenges you face when working across database platforms? Take the survey
Search
-
Re: Error laying out SQL
-
Enhancement Request: Ignore Replication Objects and Triggers
Background: I currently work with a production environment that uses replicated databases, but also work with non-replicated development and test environments. My problem is that these databases do not compare cleanly using SQL compare. Specifically, replication triggers and other objects show up as changes, when I only… -
Error when scripting objects
Discussion by ccaldwell · · Home› Discontinued and Previous Versions› SQL Packager Previous VersionsI am receiving an error when scripting out several views on one of my databases. Unknown type - sys.name which is a user defined datatype. Is this a know issue? Thanks, Chris -
Enhancement request - support MS_Description on UDT columns
-
Snapshot using Command Line
-
Missing user defined formatting styles
After one of the latest SQL Prompt for ssms updates (probably 10.5.0), SQL Prompt extension stopped recognizing my user defined formatting styles. When I try to change formatting style I have only "Built In" formatting styles available. Previously styles have been stored in "%LOCALAPPDATA%\Red Gate\SQL Prompt 10\StylesV2"… -
Scripts for User Defined Type Changes
I made a change to a user defined type that I'm using as a TVP on some stored procedures. Sql Compare is finding the difference in the UDT and trying to do a DROP/CREATE, but it's failing because those Stored Procedures reference it. In this case I feel it should be detecting those SP's need to be dropped/recreated without… -
Scripting Stored Procedures/User Defined Functions
I am trying to automate scripting a SQL Server 2005 database. I have most of the steps covered, but the one I thought would be easy is giving me some trouble. Currently, we use the Generate Scripts task from SQL Management Studio. We select all stored procedures and user-defined functions and it scripts out great. When I… -
Statistics-related bug in SDC 5
Discussion by dfurman0 · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsUsing SQL Data Compare 5.3.0.68. When there are user-defined (not auto-generated) statistics on a table, and the "Drop primary keys, indexes, and unique constraints" option for the project is checked, SDC will treat those user-defined statistics as nonclustered indexes, and will try to drop them using DROP INDEX at the… -
Version 12 not correctly finding compare keys
I have a database that has PKs defined for all its tables. When using Data Compare 11, it correctly finds and uses all of the keys. When I went to do a compare today with Version 12 (12.0.30.3199) it was unable to recognize the keys in about a third of the tables and was also not showing the PK fields in some cases. I went…
950 results