Click here to Skip to main content
14,575,160 members
Rate this:
Please Sign up or sign in to vote.
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100