Posts
Sort by recent activity
Multiple columns as unique
There is no way that you can specify multiple columns as unique. However, if you can define this unique key constraint from the database end, data generator tool will treat multiple columns in the ...
Read Only databases
Database list contains read only /snapshots databases which need to be removed from the list. If you select this database error will be generate which is obvious.
Compare Analysis Service Database
Even though this not possible now, I think red-gate needs to incorparate analysis service database compare functionality.
this will helpfull as database world is moving ahead to BI
Audit Facility
it will be better to have an auditing facility so that we can trail back the changes that we have done previously
Merge Source and Target
I have a source and target databases , in which there are few sps which I want to merge. Is it possible with SQL Compare?
Columns Order
If I insert a column to a table between the columns, I need to maintain same order in the designation table as well, which is not happening right now
Ignore COLLATE
Is there an option to ignore the COLLATE
Comparing Servers
THere should be a option to compare server settings of both servers. things like, Server Edition, Service PAcks etc.
I haven't find any such tool for this and this very important when solving serve...
Synchonizing Editor
When there is no Quesry analyser installaed sync optin gives an error when try to sysncronise as default option is Query Analyser.
It should be more wiser to select the correct option depending on ...
Synchonizing Filtering
When we need to sync, soure and target databases, there shoudl be a option to select the category fo objects.
For example, If I wan tot select, only new objects there is no qucik way of doing it. I...