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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply