I managed to talk the user into being happy with a permanent retention tape
backup of the database and in the event that she ever wants it in SQL Server
(which is what's likely to happen on day), I'll restore the database to disk
and use the SQL Server Migration Assistant from Microsoft to convert it
Thanks for the responses.
On Behalf Of Steve Wales
Sent: Wednesday, October 26, 2011 4:00 PM
Subject: Dumping contents of a view to CSV file
I've been tasked with generating a CSV file with the contents of a view in
an old database as an extra copy before the DB is decommissioned.