How to sync 2 Testlink systems?

mbaram · Post by **mbaram** » Thu May 17, 2007 1:52 pm

We need to figure out the way to syncronize two TL 1.7 systems nightly. Any ideas?

Post by **fman** » Thu May 17, 2007 3:16 pm

Please explain better (more details) what you need to do

mbaram · Post by **mbaram** » Thu May 17, 2007 4:53 pm

2 installations, in US and India, changes are made in both daily. Need to sync the changes daily.

drew · Post by **drew** » Thu May 17, 2007 7:40 pm

I think he means that he wants the information contained in one database to be transfered to the other and vice versa, on a nightly basis. I'm not aware of any such merge ability in TL itself. The only thing you could do is keep track of newly created test cases and cross export/import them on a daily basis, which is simply not practical. I think that a third party MySQL database merge tool is your best option.

svanuitert · Post by **svanuitert** » Fri May 18, 2007 4:40 pm

Since TL is based on MySQL, just ensure you are using MySQL version 5.x or greater and use the server replication feature of mysql. As long as the TL code is identical at both of your locations (you could use rsync to keep TL syncronized), your data in the databases should be almost live as changes are made.

Scot

Post by **havlatm** » Sat May 19, 2007 7:29 pm

TestLink has not own synchronization feature. You can do it via common db related tools. But I'm not aware how could be solved conflicts.
I suggest to think about one system shared via intranet or internet. You can patch access to TL for exact range of IP address to be sure about security (internet case).