Teoman Sahin
asked on
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?
You can apply all the relevant codes to generate all DB objects of all 3 DBs, into the overall database.
ASKER
could you please give detailed information about how to do?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.