Comments
Sort by recent activity
I would agree with the original request that it would be good if SQL Compare also (optionally) migrated database settings across, that is those that this makes sense for such as 'Paramaterization' as to OP mentioned 'Allow Snapshot Isolation' and others like 'Is Read Committed Snapshot On'.
This is not the isolation level Red-Gate Compare runs under as your reply deals with but the actual settings for the database as can be accessed via SQL Server Management Studio when right clicking on the DB and choosing 'Properties' -> Options. / comments
I would agree with the original request that it would be good if SQL Compare also (optionally) migrated database settings across, that is those that this makes sense for such as 'Paramaterization' ...
Auto update stats is on and I have have also for all the system tables ran update statistics with resample. / comments
Auto update stats is on and I have have also for all the system tables ran update statistics with resample.
I think the reason the performance has recently got worse is due to our increasing the number of partitions we store tables and indexes on. We have recently switched from fixed quarterly to fixed monthly partitions.
It may also be the case that using the command line version works MUCH faster than the Windows GUI one. Not sure on this yet though but a command line I kicked off earler today did finish before I bothered to check it several hours later, whereas the Windows GUI has been stuck on the reading indexes step for 3 hours since. I will run a few tests next week to see if this is the case. That the command line works is not a fix as far as I am concerned as we do need to change the project config after the schema read has happened and/or only upgrade a few tables/procs now and again (all not possible using the command line). / comments
I think the reason the performance has recently got worse is due to our increasing the number of partitions we store tables and indexes on. We have recently switched from fixed quarterly to fixed m...
This is still an ongoing issue, if anything it is getting worse as the long reading indexes step now happens on smaller databases than before. / comments
This is still an ongoing issue, if anything it is getting worse as the long reading indexes step now happens on smaller databases than before.
This issue is also hitting us and SQL Compare is now taking a couple of hours to do the compare on a moderate sized DataWarehouse. Running SQL Server 2012 SP1 CU3. For reasons that I cannot detemine it only hits certain instances of SQL, especially one in which there is no data in the database. A fix would be appreciated. / comments
This issue is also hitting us and SQL Compare is now taking a couple of hours to do the compare on a moderate sized DataWarehouse. Running SQL Server 2012 SP1 CU3. For reasons that I cannot detemin...
Has the auto mapping thing been made optional yet? This causes us endless issues and we almost never rename columns - being a datawarehouse. It is one of the most irritating features in SQL Compare. / comments
Has the auto mapping thing been made optional yet? This causes us endless issues and we almost never rename columns - being a datawarehouse. It is one of the most irritating features in SQL Compare.
eddie davis wrote:
What version of SQL Compare are you using?
10.1.0.102
eddie davis wrote:
What version of SQL Server are you using for both source and target?
10.50.2811 (SQL Server 2008 R2 SP1 CU6) / comments
eddie davis wrote:
What version of SQL Compare are you using?
10.1.0.102
eddie davis wrote:
What version of SQL Server are you using for both source and target?
10.50.2811 (SQL Server 2008 ...
Niall wrote:
Ie Source server has default fillfactor = 90%, Target server has fillfactor =80%
Actually it seems the Fillfactor setting gets added even when both the Source and Target have the same setting. / comments
Niall wrote:
Ie Source server has default fillfactor = 90%, Target server has fillfactor =80%
Actually it seems the Fillfactor setting gets added even when both the Source and Target have the ...
Actually I think this isa bug, as in the tool generates invalid SQL, not a feature request, can you please fix it without polling folk about the priority. / comments
Actually I think this isa bug, as in the tool generates invalid SQL, not a feature request, can you please fix it without polling folk about the priority.
Anu Deshpande wrote:
3. SP-2951: Centralised Snippets/Layout Settings
This is a feature I would also like to see incorporated as I extensively use snippets and would like to be able to share them with my team and for that matter my laptop which I use for support purposes occassionally. / comments
Anu Deshpande wrote:
3. SP-2951: Centralised Snippets/Layout Settings
This is a feature I would also like to see incorporated as I extensively use snippets and would like to be able to share t...