Importing into Test Database

[Justin Allen]

SQL 2000, Windows 2000. I need to find a way to export our data from
our production database and import it into a test database. I can do
it to a freshly created test database I just have trouble doing it
once the test database is already populated. Is there a script I can
write that will automate it by
1) Deleting the test database
2) Creating a new one
3) Exporting the production tables and views
4) Importing into the new test database

What are my options here?

Thank you in advance.

[Simon Hayes]

"Justin Allen" <co****************@hotmail.com> wrote in message
news:3b*************************@posting.google.co m...

SQL 2000, Windows 2000. I need to find a way to export our data from
our production database and import it into a test database. I can do
it to a freshly created test database I just have trouble doing it
once the test database is already populated. Is there a script I can
write that will automate it by
1) Deleting the test database
2) Creating a new one
3) Exporting the production tables and views
4) Importing into the new test database

What are my options here?

Thank you in advance.

See my reply to your previous post.

Simon

[Dariush]

co****************@hotmail.com (Justin Allen) wrote in message news:<3b*************************@posting.google.c om>...

SQL 2000, Windows 2000. I need to find a way to export our data from
our production database and import it into a test database. I can do
it to a freshly created test database I just have trouble doing it
once the test database is already populated. Is there a script I can
write that will automate it by
1) Deleting the test database
2) Creating a new one
3) Exporting the production tables and views
4) Importing into the new test database

What are my options here?

Thank you in advance.

If you are looking to simply bring all the data over from the source
to the destination db, you may try to dump the tables to a sql file
and run the load on the destination db.

Also have a look at sqlporter database migration tool
from realsoftstudio.com

Hope it helps.