If not when how could I merge databases controlled by one project into one database. Thanks in advance.
2007-02-18 23:37:09 · 5 answers · asked by Anonymous 2 in Computers & Internet ➔ Programming & Design
Thank you all for the support. Now, how could import data from one database to another. Can you give me some resources if there is any? Thank you.
2007-02-20 23:52:46 · update #1
i don't know why you need more than a database into one project, but the best way i think is to import the tables and stored procedures from one database to another, hoping it will not make any conflicts in your new database..
2007-02-18 23:42:13 · answer #1 · answered by abd 5 · 0⤊ 0⤋
Use one database where possible with multiple tables. An exception to that would be if the data contained in each of the different databases did not rely on each other, or link to each other. If they can be logically separated and stand on their own, then you can use multiple databases. Using one database will make things easier, so do so if possible.
2007-02-19 01:23:01 · answer #2 · answered by Pfo 7 · 0⤊ 0⤋
It is better to use one database for your project.
To merge the database you can import data from one database to the other. You can select to import the table design (schema) & data to the database, and you will get the tables from one database imported to the other.
2007-02-19 00:40:44 · answer #3 · answered by Kamran 2 · 0⤊ 0⤋
I think this website might help you a lot for your needs. It's where they sell SQL database and you might need it. Just come to check it out!
2016-05-24 07:14:55 · answer #4 · answered by Anonymous · 0⤊ 0⤋
one database is enough. its more easy to maintain and control.
to merge databases, use some database replicator, or you can build your own replicator.
2007-02-18 23:57:32 · answer #5 · answered by Manzana verde 5 · 0⤊ 0⤋