What are the challenges you face when working across database platforms? Take the survey
Search
-
feature suggestion: Code sniffing
Just a wee suggestion that I think would fit into SQL prompt quite well. Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a defined standard, warnings on bad practices etc. You know all those little annoying things like no clustered index, use of… -
Re: Unknown type - dbo.dbo
Comment by richardjm · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsCan I ask if you have any user defined types in your database and what they may be defined as. We came across this problem in testing and we thought we had it fixed. Any information on types used would be most helpful - perhaps you could send me a SQL Compare snapshot of the structures of the two databases? Thanks -
New DB Generation - user defined data types?
Discussion by jchizmas · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI've played with the demo and just purchases this yesterday, but I am running into an issue I don't know how to solve: After my database has been attached and checked in (I'm using TFS, but the same thing happens in the sample repository). 1. Create a new Database 2. Link Database to source control. This all works as… -
Re: db_roles
-
Unmodified DLLs are not including in package.
-
SQLTest view not showing existing tests
I previously installed SQLTest and tSQLt on a SQL Server instance and SQLTest was working fine. Its been several months and going back to this project. When I open SQLTest it no longer shows the list of defined tests or even SQLCop tests. The database objects are all there and I can run them manually in SSMS and they seem… -
Jub Duration Alert Issues
I am seeing an issue with the "Ignore if the job run time is less than ??? seconds" setting. Is doesn't seem to be working. I set it to 30 seconds and I still receive alerts for jobs that complete in less time than that even though the deviation exceeds the defined threshold. I also have seen alerts for jobs that do not… -
User-Defined Dependency Tracking
I don't think this is redundant, I checked around the forum and help topics and found no info on this item. Some of our stored procedures do EXECs on strings to manipulate data. There are usually db objects referenced by these EXECs. Dependency Tracker doesn't track these "invisible" dependencies but we do need to track… -
Error Generating Script for Difference in Type
I'm getting an error whenever I try to generate a script for a difference in a Type object. For example, in Target database the type is defined as: CREATE OR REPLACE type num_table is table of varchar2(10); In Source database script directory the type is defined as: CREATE OR REPLACE type num_table is table of number; Try… -
BUG: Scripting user-defined table types changes
Hi, I've encounter a problem with changing user-defined table types. The correct script where these types change would be 1. DROP all objects which use this type as input parameter 2. DROP/CREATE type 3. CREATE all objects again I was under impression that ReadyRoll works like this, but I've changed a table type recently…
951 results