Activity overview
Latest activity by dineshasanka
Compare only indexes
Is it possbiel to compare only indexes and generate sync. script
Sync Wizard
in the syncronization wizard, you can set option to Compare database following suncronization.
This setting will be there when you run the sync wizard again. However, if there is an error during th...
Actually, today I came across with this issue.
I was comapring huge database and by mistake i have select the same database.
Rather than removing tis feature isn't it better to alert the user indicating that he is going to comare same database / comments
Actually, today I came across with this issue.
I was comapring huge database and by mistake i have select the same database.
Rather than removing tis feature isn't it better to alert the user indic...
I can't see any point of comparing a database to the same database. It will be identical anyway.
if you enter by mistake, it will take some time to recognise that you have done a mistake.
Better if you can provide a alert that the user is comparing same database / comments
I can't see any point of comparing a database to the same database. It will be identical anyway.
if you enter by mistake, it will take some time to recognise that you have done a mistake.
Better if...
Generating Scripts
Currently, while sync there is a option to edit script in the SSMS. But is it possible to open those in one instance of SSMS as separate tabs rather than opening them in separate instances.
sp_refreshview
I had a view which was not in the destination. this view is used by several sps.
but in the scripts for sps, sp_refreshview 'oldview' statment is written which returns an error.
Group By option
Currently SQL Comapre supoprts two group by methods that is type of objects and type of difference.
I need to generate syns scripts depending on the both of above methos. that is I need scripts for...
Can compare same database
This might be a small issue.
you shouldn't have the option of comapring same database which is possbiel right now.
Comapring with backups
Does SQL Compare supports only full backups not differential backups
General Comments
I think there is a vast improvement in SQL Compare 8.0. specially in the area of synchronization. It is much fater than before.
Also, UI seems to be much simpler provided that sqith option is enabled.