Solved

to combine more databases into one database

Posted on 2015-01-13
4
48 Views
Last Modified: 2015-01-19
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
Comment
Question by:Teoman Sahin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 40548380
You can apply all the relevant codes to generate all DB objects of all 3 DBs, into the overall database.
0
 

Author Comment

by:Teoman Sahin
ID: 40548383
could you please give detailed information about how to do?
0
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 40548398
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
 
LVL 7

Accepted Solution

by:
Swatantra Bhargava earned 500 total points
ID: 40548611
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question