469,923 Members | 1,739 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

merging of two mysql databases having two different ports

I want to merge TESTLINK and BUGZILLA databases into one, even though they have mysql DB but i have installed in different ports(TESTLINK-3306 and BUGZILLA-3307). so with respect to TEST CASE-ID in test link which are failed or blocked or whatever it should raise a defect in the bugzilla automatically. I am unable to understand which tables i need to go for joining or whats suppose to be done.

So iam using JAVA in order to write the code.The merging of DB's should should be done.Kindly help me out with the proper solution.

Kindly provide the code as well.

I have gone though all installation pdf's and many more sites that could merge two mysql DB's, so its not helping me out in any ways.
May 23 '13 #1
2 1615
983 Expert 512MB

I don't know how to help you with the database merge, and I'm not certain if it is the correct approach. Directly manipulating the tables can easily violate the application logic of either TESTLINK or BUGZILLA. You really should use appropriate APIs, instead.

There is a Bugzilla REST API that you could use to insert records from Java. This is the first result of a Google search for "bugzilla api", and it looks to be reasonable.

There is also a Google tool j2bugzilla that you might want to consider. It's set up as a Maven repository.

Researching TESTLINK's API is left to you.

I know that REST APIs are a nusiance to work with, but once you get started, it's not hard to write a Java API specific to your needs.

As for us providing code - please don't ask us to do your job. We will gladly help you where you have difficulty, but you have to provide us something to help you with.

Kind Regards,
May 23 '13 #2
thanks for the reply
May 28 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Benedictum | last post: by
11 posts views Thread by Joshua Beall | last post: by
1 post views Thread by vineyard_saker | last post: by
9 posts views Thread by noor.rahman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.