Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?




 All Forums
 Support
 DB Ghost Support Forum
 choosing tables to sync data
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

LtMandella


5 Posts

Posted - 10/31/2014 :  18:37:27  Show Profile Send LtMandella a Private Message  Reply with Quote
Am I missing something or is there no regex or other search method to choose specific tables for data syncing aside from the "select all, deselect all, select all with rows"?

p.s. DBChangeManager is a great tool!

Google AdSense

USA
Mountain View


dbghost



66 Posts

Posted - 11/03/2014 :  04:50:23  Show Profile  Visit dbghost's Homepage Send dbghost a Private Message  Reply with Quote
If your tick the "Automatically select tables with source data" option (top left of screen) and an optional regex filter box appears. So tables that have source rows and names matching the filter will be data compared. NB the test filter button highlights matching tables in green.

But the is regex only applies in "automatic" selection mode.

Of course, you can also tick the tables individually when not in automatic selection mode.
Go to Top of Page

dbghost



66 Posts

Posted - 11/03/2014 :  04:51:26  Show Profile  Visit dbghost's Homepage Send dbghost a Private Message  Reply with Quote
Sorry should read top right of screen.
Go to Top of Page

LtMandella



5 Posts

Posted - 11/03/2014 :  09:47:10  Show Profile Send LtMandella a Private Message  Reply with Quote
quote:
Originally posted by dbghost

If your tick the "Automatically select tables with source data" option (top left of screen) and an optional regex filter box appears.



Excellent, that should be perfect. I don't understand why I didn't notice it yet. Will give it a go and let you know...

thank you!
ken
Go to Top of Page

dbghost



66 Posts

Posted - 11/03/2014 :  12:08:19  Show Profile  Visit dbghost's Homepage Send dbghost a Private Message  Reply with Quote
Also the regex is a special Innovartis regex which allows not@ prefix to the pattern string. The not@ means do the opposite of whatever follows effectively reversing the matched set, useful if you ever need to compare all names that do NOT match the pattern. e.g. not@Fred will match all table names that do not contain Fred. We added this syntax because it is quite hard to achieve a reverse match with pure regex alone.
Go to Top of Page

LtMandella



5 Posts

Posted - 11/03/2014 :  12:24:01  Show Profile Send LtMandella a Private Message  Reply with Quote
quote:
Originally posted by dbghost

Also the regex is a special Innovartis regex which allows not@ prefix to the pattern string. The not@ means do the opposite of whatever follows effectively reversing the matched set, useful if you ever need to compare all names that do NOT match the pattern. e.g. not@Fred will match all table names that do not contain Fred. We added this syntax because it is quite hard to achieve a reverse match with pure regex alone.



NICE! I am trying to figure out how to script data for all tables with rowcount between 1 and 50K, EXCLUDING certain tables. not@ should be perfect.

thank you for the info!
ken
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free