Home All Groups Group Topic Archive Search About

data from production to test

Author
28 Jul 2006 12:15 PM
Robert Bravery
HI all,

Whats the easest way of getting data from the production database into the
test database, overwriting the junk in the test database

Thanks

Robert

Author
28 Jul 2006 12:20 PM
Tracy McKibben
Robert Bravery wrote:
> HI all,
>
> Whats the easest way of getting data from the production database into the
> test database, overwriting the junk in the test database
>
> Thanks
>
> Robert
>
>

Restore a current backup, and then re-deploy any DDL scripts that are
still under development...


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Author
28 Jul 2006 12:50 PM
Alexander Kuznetsov
> Restore a current backup, and then re-deploy any DDL scripts that are
> still under development...

then scramble all sensitive data

AddThis Social Bookmark Button