Settings and activity
7 results found
-
20 votesDave supported this idea ·
-
52 votesDave supported this idea ·
-
27 votesDave supported this idea ·
-
19 votesDave supported this idea ·
An error occurred while saving the comment -
40 votes
An error occurred while saving the comment Dave commentedAgreed! It should only compare the static data tables, not try and delete everything from every table that's not in static data. At least by default.
Dave supported this idea · -
5 votesDave shared this idea ·
-
6 votes
An error occurred while saving the comment Dave commentedTracking the creation of addition file groups and files would be nice. Also ANSI NULLS, Padding etc, so our team all create new objects with the same settings. (File groups are also part of the database options)
I.e. pretty much everything that is shown when you right click on a database in SSMS and click "Script database as..." - thank you.Dave supported this idea ·
Agreed! When comparing DATE vs DATETIME, even if the time part is always 0:00:00.000, it still says they don't match.
In my case, the source database was a SQL 2005 database which didn't have the DATE type, and destination SQL 2016