Click here to Skip to main content
15,741,692 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friends,

I have Two databases in my SqlServer 2005.

For Example : I have Database(SchoolDB) and another Database(CollegeDB)

Now From these Two DATABASES I need to make One Database.....OK.

My requirement is : In CollegeDB i have two Tables StudentInformation and TeachersInformation. So i have to copy these two tables to SchoolDB Database with all the data in it.

Please can anybody help me, how to do this.


1 solution

U can import those table in your newly created database.
Steps :
1) Right click on your newly created database.
2) select Task >> Import data.
3) provide your source database name and target database name.
4) select tables that you want to import.

in this way you can get tables with same datatypes and constaints.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900