copy database wizard vs import and export wizard

Hi
I would like to know what is the best way to copy the tables from production db to development while leaving the db intact in the production server.
Also would like to know the main difference between import export wizard and copy database wizard in sql server 2000 and 2005

thanks
atwork2003Asked:
Who is Participating?
 
SireesCommented:
If you need to copy only data use import export wizard

If you want to copy both objects and data ->use copy database wizard
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
If you just need to copy the data, then use IMPORT/EXPORT wizard,
0
 
SireesCommented:
<< best way to copy the tables from production db to development while leaving the db intact in the production server>>

Another alternative is to backup the database and restore it on developemnt environment
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
atwork2003Author Commented:
can I save the copydatabase wizard process stored as dts package and do some sql quering against the data using tsql task.

Also when u say database odject that include table , rows and column and I want to import that but not neccessary the storeprocs, trigers etc.
thanks
0
 
imran_fastCommented:
>>can I save the copydatabase wizard process stored as dts package and do some sql quering against the data using tsql task

You can do it! but what if the destination already have the database with this name.

Copy database will copy the exact database to the new server you cannot select part of it.like only tables or only stored procedures.
0
 
atwork2003Author Commented:
can I use import export wizard for this task and store the package. I will like to make specific changes to the data using tsql in import export wizard.
Thanks
0
 
imran_fastCommented:
Yes you can use Import export for that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.