I'm looking to purchase a SQLyog license but I need to know is it possible to sync a remote and local database but exclude certain parts like the domain name and folder paths?
Also is SQLyog good at revision control for databases?
Will the scheduled backups only run if the application is on?
1) Data sync will bring selected tables from the databases defined aand *in sync* (that is why we call it Data Sync).and databases may be on different servers or on the same server. Any filtering option that can be described using a WHERE-clause againstare supported.
2) SQLyog is not a tool for version control if that is what you mean by 'revision control'. I really do not understand how such applies to a Database server at all. But you can make backups/dumps with SQLyog and files created can be under version control (using any fit version control client software).
3) Scheduled backups are initiated from the Windows Scheduler service (or CRON if you use Linux/Wine). SQLyog does not need to run.
Please download and try SQLyog TRIAL from http://www.webyog.com/en/downloads.php . You will be able to ask more precise questions after having tried it for a few hours or days.
