• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 58
  • 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
 
HuaMin ChenSystem 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
 
HuaMin ChenSystem 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 BhargavaTechnology no BarCommented:
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

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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