sja manuel or xml tag descriptions

[tao_zhyn]

I may have missed it, but is there a manuel to tell about all the tags that sja xml file uses?

I am trying to use this tool on a linux box, and must edit the file manually. I did find the page with an overview of the xml schema used, but it did not explain enough about the tags. Like what actually specifies, other than being the root tag.

Also is sja able to sync stuctures only? I am guessing that there is a xml tag to specify this. ()

What I really want to know is if I can use sja to test if two databases differ. Then after reviewing what differs, I may run another sja job to sync them.

Thanks

[Shadow]

Sja can be used to:

1. sync content and structure

2. schedule or issue a group of SQL queries (v3.7 beta only!).

Sja cannot be used to view the differences of two dbs, it syncs their content immediately. From v3.7 on it supports two-way sync as well.

Which parts of its XML schema is unclear to you?

[tao_zhyn]

You said sja can be used to ” 1. sync content and structure ” is that inclusive?

What I mean is does it have to do both or can I just do the sync on the structure?

I was just wondering if there was more to

Code:

, what does version attribute do? Just allows me to version me different schemas?

Code:

, is there other types of jobs? I was hoping there has some sort of

Code:

, but you have said sja cannot do this. Or something like

Code:

, so I could just sync structure only.

Those were 2 of my main questions about he xml.

Thanks for the reply.

opps never noticed in my last post that the xml tags i typed where not showing. Fixed them in this post

[Ritesh]

SJA 1.1 can only be used to sync data and not structures. To sync structure use Structure Synchronization Tool provided with SQLyog.

The features of SJA (therefore the structure of XML) has changed from 3.6x to 3.7. SQLyog 3.6x has SJA 1.1 and 3.7 has SJA 2.0. The version attribute is just a hint for SJA to be backward compatible.

SJA 1.1 could only be used for syncing data but with SJA 2.0 (available with SQLyog 3.7 BETA and Linux version coming soon) you can send formatted resultsets thru email. In SJA 1.1, you can have only one type of job i.e

Code:

With SJA 2.0, you will be having two types of jobs

Code:

and

Code:

HTH

[Author]

Posts