October 26, 2003 at 11:04 pm
Hi all,
Silly question but is there any kind of utility (other than bcp) to "upgrade" a SQL 7 format file to a SQL 2000 format file? I have over 150 format files to change for a data warehouse and I'm not looking forward to doing it. Many thanks.
James Stover, McDBA
October 27, 2003 at 2:42 am
Not sure about this, but you could try just changing the '7.0' on the first line to '8.0'. The equivalent works for upgrade from 6.5 to 7.0, so worth a try. I doubt they have fundamentally changed the bcp program between 7 and 8. If this does work, you could easily record a Word macro to do the replacement, save and close, and then if you have any VB/VBA, enclose the existing macro code in a 'while' loop ('while documents.count > 0') to cycle through all open docs. Then if you open all the files in Word and run the macro, you should be laughing...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 27, 2003 at 5:32 pm
The main difference is that the 8.0 format file requires the collation for each column entry. But the macro thingy might work. Thanks for the suggestion!
James Stover, McDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply