When using the MySQL Data Compare tools is there a way to look at data, but ignore a string like a URL. For example, I have a development and a production version of a database. One databases is attached to the development version of a Wordpress environment, and the other database is attached to the production version of the Wordpress environment. In some cases the URL of the Wordpress App is saved into the meta data.
I need to compare and synchronize, but I need to ignore the source and target URLs because that isn't a difference I want to synchronize.
When comparing I would like to ignore the source and target URLs in the data, and look for differences related to other data. I would like to be able to exclude some URL string patterns from the comparison process.
When synchronizing, it would be great if I could force the occurrence of the source URL in a row to be synchronized, to be written to as the target URL.
Any thoughts on how I could do this with the product. If the synchronizing objectives aren't possible with the synchronization wizard, is there a search and replace function that I could do?
Your help is appreciated.
Compare/Synchronize Data with URLs
Re: Compare/Synchronize Data with URLs
Some more thinking...
My work around for this is to do a search for the source app's URL in the source database, replace with the target app's URL, then use that refined copy of the source database as the source in the MySQL data compare.
Any solution would have to functionally create this capability. Maybe this is the best way to do it.
My work around for this is to do a search for the source app's URL in the source database, replace with the target app's URL, then use that refined copy of the source database as the source in the MySQL data compare.
Any solution would have to functionally create this capability. Maybe this is the best way to do it.
-
alexa
Re: Compare/Synchronize Data with URLs
You can exclude specific columns from comparison as follows:
1. On the 'Source and Target' page of the Data Comparison wizard, specify Source and Target.
2. On the 'Mapping' page, click the three-dotted button which is against a table name in the grid. The 'Column Mapping' dialog opens.
3. Unselect the columns you don't wish to compare.
4. Click the 'OK' button.
5. Click the 'Compare' button. As a result, synchronization script will be generated.
1. On the 'Source and Target' page of the Data Comparison wizard, specify Source and Target.
2. On the 'Mapping' page, click the three-dotted button which is against a table name in the grid. The 'Column Mapping' dialog opens.
3. Unselect the columns you don't wish to compare.
4. Click the 'OK' button.
5. Click the 'Compare' button. As a result, synchronization script will be generated.