October 28, 2006 at 7:05 pm
Hello I am a software developer with minimal SQL server administration skills. Currently I am using SQL Server 2000.
I need to know if there is a way to copy a particular table from a database, and to copy the table into a different database.
Basically on a project I am working on we are using a table named "Customers" from a database named QTR. We need to copy this database table into a different database named "Research".
How can this be done? Is if very complicated?
October 30, 2006 at 5:51 am
This sound starightforward just go to destination database right click and select import database ,
and just follow the instructions be careful your from and to boxex are accurate before hitting run.
if it is on a different server then make sure you are at destination as well.
October 30, 2006 at 10:30 am
William,
Lydia is referring to the Import/Export Wizard and it is fairly easy to use. I recommend you choose 'Copy objects and data between SQL Server databases' because it gives you the option of copying indexes, triggers, and foreign key constraints. You won't have that choice with either of the other two options.
Greg
Greg
October 31, 2006 at 3:05 pm
Another alternate is to use SELECT fieldList INTO newTable FROM existingTable to avoid the headache in creating a new table.
September 20, 2007 at 12:50 am
Hi, I want to copy production database to a testing server. The production database is too big. Is there a way that we can shrink down the db size (taking a year data for example) when we copy it to the testing server?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply