Comments
Sort by recent activity
Thanks Chris.
The problem with SQL Data Compare (and SQL Compare, for that matter) is when I need to compare databases from diffrent servers with different Windows credentials.
Will it make SQL Data Compare 8? [image] / comments
Thanks Chris.
The problem with SQL Data Compare (and SQL Compare, for that matter) is when I need to compare databases from diffrent servers with different Windows credentials.
Will it make SQL Dat...
The funny thing is that it detects the existence of a new version but cannot download it (unless I specify the proxy settings).
I've changed the required runtime to v2.0.50727. Let's ee how it works now. / comments
The funny thing is that it detects the existence of a new version but cannot download it (unless I specify the proxy settings).
I've changed the required runtime to v2.0.50727. Let's ee how it work...
I have a feeling that this should be optional.
Probably another option on View / Options / Disassembler. View Source would override all options. / comments
I have a feeling that this should be optional.
Probably another option on View / Options / Disassembler. View Source would override all options.
I wounder how I missed that in SQL Data Compare 5. :oops: / comments
I wounder how I missed that in SQL Data Compare 5. :oops:
And I have suggested it before. [image]
I have thought of the trigger. In the present example it would be easy to have a trigger to set the the DateTime value to getutcdate(). But, what if I have another DateTime column "EfectiveFrom" that is a static value just form that synchronization operation? / comments
And I have suggested it before.
I have thought of the trigger. In the present example it would be easy to have a trigger to set the the DateTime value to getutcdate(). But, what if I have another...
I'm also facing a problem where I need to generate rows referencing a subset of the referenced tables.
Isn't this a common use scenario? / comments
I'm also facing a problem where I need to generate rows referencing a subset of the referenced tables.
Isn't this a common use scenario?
I'd like to have the possibility to generate drop/create scripts for objects like procedures, functions, triggers, views and anything else that can be dropped without losing data. / comments
I'd like to have the possibility to generate drop/create scripts for objects like procedures, functions, triggers, views and anything else that can be dropped without losing data.
Nope. I would need to map more than one schem on my local database to the same schema on the QA database. / comments
Nope. I would need to map more than one schem on my local database to the same schema on the QA database.
No, because I don't want to compare data - SQL Data Compare does a very good job at that.
I want to compare "equal" tables that just happen to have different names.
Can I map Schema1 in one database to both Schema1 and Schema2 in another? I could live with tables with the same name in another schema. / comments
No, because I don't want to compare data - SQL Data Compare does a very good job at that.
I want to compare "equal" tables that just happen to have different names.
Can I map Schema1 in one databas...
I ave an application that has a configuration database (menu items, settings, etc.)
In my development machine my database has a differente schema from the QA (and production) database.
The MyTable in QA is the MyTable view on my machine that joins data from MyTableQA (replica of QA's MyTable) and MyTableLocal (local overrides).
This way, I can keep all APIs (SPs, services, etc.) in sync with QA.
Everytime I need to use my local database, I only have to sync with QA, which SQL Data Compares does nicelly. / comments
I ave an application that has a configuration database (menu items, settings, etc.)
In my development machine my database has a differente schema from the QA (and production) database.
The MyTable ...