After reading the tracker and looking at some synchronization tools I came up with a sample interface. Although it is very raw but atleast it gave me an idea of what should be there in the interface.
Saturday, May 16, 2009
Rough Interface!
After reading the tracker and looking at some synchronization tools I came up with a sample interface. Although it is very raw but atleast it gave me an idea of what should be there in the interface.
Thursday, May 14, 2009
Tracker
I read the tracker links and got to know that there are three types of synchronization that I have to perform.
First, structure synchronization that includes making the structure of two tables in databases same. This includes making the fields in table same.
In type synchronization data types of the tables will be matched and then synchronized.
Then comes synchronization of the data.
All these synchronizations can be on one server or on remote servers.
Also I saw the interface of the tool Navicat mentioned in the tracker. I understood that the interface should be such that tables of the two databases should be shown in two columns and the user could select the tables which are to be synchronized. Also results should be shown to the user as which queries have been executed or which tables have been synchronized.
Tracker also gave some pointers as how can synchronization can be improved like by maintaining order of fields, or by maintaining keys and indexes. I also think that if these are maintained in structure synchronization then the ultimate goal of data synchronization can be achieved easily.
First, structure synchronization that includes making the structure of two tables in databases same. This includes making the fields in table same.
In type synchronization data types of the tables will be matched and then synchronized.
Then comes synchronization of the data.
All these synchronizations can be on one server or on remote servers.
Also I saw the interface of the tool Navicat mentioned in the tracker. I understood that the interface should be such that tables of the two databases should be shown in two columns and the user could select the tables which are to be synchronized. Also results should be shown to the user as which queries have been executed or which tables have been synchronized.
Tracker also gave some pointers as how can synchronization can be improved like by maintaining order of fields, or by maintaining keys and indexes. I also think that if these are maintained in structure synchronization then the ultimate goal of data synchronization can be achieved easily.
Subscribe to:
Posts (Atom)