Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Five of us are working on a project and there is this form where we get details and store it in a mysql db. This will serve as the master data for us and we need to test our other modules to the max with this DB. So if i fill the form for some 25 times and ask others to do the same, now there will be five different local database.How do I integrate all those into one? I need one huge DB at the last.

Could be the dumbest question, but still, help me :)
Posted
Comments
[no name] 14-Sep-13 7:03am    
So why don't you create one database and all of you use the same database?
Joan M 14-Sep-13 9:31am    
If you don't want / can work on a big database for all the team mates, you can always export the local databases to text and obtain the proper SQL files.
After that you will be able to remove all the table creation and import the data back into the resulting database.

1 solution

Is there any problem with using something like this: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html[^] ?

This, of course, begs the question per the above suggestion that you all use the same table as your target - for, in general, if you can all observe the same table(s) you can all use the same table(s). Certainly permissions for this, if required, are available for a development team!

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900