I need to refresh data from a SQL 6.5 environment for QA purposes (hopefully generic solution should work for 7 & 2K). I need to select blocks of data in demand or in an automated fashion.
I would like to know the experiences of anyone who has done this.The SQL commands DUMP and RESTORE work well.
-PatP|||I don't think you can RESTORE on 7.0/2K from a dump device created on 6.5
Use a combination of BCP...OUT/BULK INSERT preceeded by either DELETE or TRUNCATE on the target.|||Minor brain fart there... In 6.5 it ought to be DUMP and LOAD. The use of BACKUP and RESTORE didn't start until 7.0.
rdjabarov raises a good point though, in that BCP could be used with all three platforms (assuming you are using the BCP that ships with SQL-2000). A bit of script for OSQL and some BCP action, and you could be in business!
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment