Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • Last Modified:

to combine more databases into one database

we have three different database and we would like to combine tables into one database so Is it possible to prepare these 3 databases into only one database?
0
Teoman Sahin
Asked:
Teoman Sahin
  • 2
1 Solution
 
HuaMinChenBusiness AnalystCommented:
You can apply all the relevant codes to generate all DB objects of all 3 DBs, into the overall database.
0
 
Teoman SahinAuthor Commented:
could you please give detailed information about how to do?
0
 
HuaMinChenBusiness AnalystCommented:
For table, right-click table > Script table as > Drop and create to > Query

and collect all queries in the same way, for all other DB objects. Then you apply the overall query of all 3 DBs into overall DB.
0
 
Swatantra BhargavaTeam LeaderCommented:
Create database A1

Create SQL script file of another database say like B1 after exporting all the tables
Now execute this script in A! database

Create SQL script file of another database say like C1 after exporting all the tables
Now execute this script in A! database

Now your final Database is A1

Hope this will help you...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now