Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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