Click here to Skip to main content
12,300,379 members (39,538 online)
Rate this:
 
Please Sign up or sign in to vote.
hello my dear frndz !

wishing you a happy new year 2013 to all of you.

presently am using Sqlserver 2005 database. i need help from you guys.

i have a database(oldCollegeDB) with 55 tables in it. Now i want to dump these 55 tables to new database (NewCollegeDB)

Please can you help me guys, how to write a query for this.

thanks for ever !!.
Posted 1-Jan-13 21:49pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

1.
take backup of oldCollegeDB database name file for,e.g. oldCollegeDB.bak

2.
create new database name it NewCollegeDB

3.
now, restore oldCollegeDB.bak file in NewCollegeDB

Happy Coding!
Smile | :)
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Make use of the Copy Database Wizard[^].
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Have you tried generating db table's the scripts? You can generate a script to create the tables then generate a script to insert the data.

SP_ Genereate_Inserts[^] for generating the data insert script.

--OR--

You can use Microsoft SQL Server Database Publishing Wizard[^]

Good luck,
OI
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160525.2 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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