Is it more convenient to have multiple databases in one project in Visual Basic 2005 and SQL Server 2005?

Question

If not when how could I merge databases controlled by one project into one database. Thanks in advance.

Answer 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..

Answer 2

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.

Answer 3

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.

Answer 4

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!

Answer 5

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.