Red Gate forums :: View topic - Where clause filter gets scripted
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Where clause filter gets scripted

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
msegura



Joined: 04 Jun 2011
Posts: 1

PostPosted: Sat Jun 04, 2011 7:48 pm    Post subject: Where clause filter gets scripted Reply with quote

Hi everyone. When I use the where clause filters to do my data comparison, they also get included into the scripting which inherently creates an issue when I try to run an update statement. Does anyone know how to exclude it in the actual scripting? It seems very strange how this was designed. I do set the "Use the same where clause for both data sources" option in the where filter which makes sense but I don't mean for it to be literally used in the scripting. Any help is appreciated.
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Mon Jun 06, 2011 1:19 pm    Post subject: Where clause filter gets scripted Reply with quote

Thanks for your question.

SQL Data Compare 8 includes the WHERE clause in the update scripts. This causes issues if it selects from another table and that table hasn't been updated yet. It's not easy to tell when this is going to happen.

SQL Data Compare 9 doesn't seem to have this issue, it may be worth upgrading/evaluating it if you haven't done so already.

I hope this helps.
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group