Comments
Sort by recent activity
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 ...
I'm not sure if it's worth it, but the Managed AddIn Framework can help here (http://blogs.msdn.com/b/sidharth/archive/2009/05/03/working-with-the-managed-addin-framework-system-addin.aspx). / comments
I'm not sure if it's worth it, but the Managed AddIn Framework can help here (http://blogs.msdn.com/b/sidharth/archive/2009/05/03/working-with-the-managed-addin-framework-system-addin.aspx).
I've been wishing for that for a LOOOOOOOOOOOOONG time. / comments
I've been wishing for that for a LOOOOOOOOOOOOONG time.
It's not as obvious as it looks. Should it be global? Should it be per tab? How will it impact performance? (you can use Antzs far the last one [image] )
The fact is that I end up changing this a lot because, sometimes it's a decimal value, sometimes it's a bit mask. I'm OK with changing this multimple times for the same code window. / comments
It's not as obvious as it looks. Should it be global? Should it be per tab? How will it impact performance? (you can use Antzs far the last one )
The fact is that I end up changing this a lot becau...