6.5 export - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

6.5 export

Author

Topic

cici
Starting Member

2 Posts

Posted - 2009-10-12 : 12:59:50

I have a legacy SQL Server 6.5 database that I need to get the data out of. I am going to be importing the data into MySQL. How can I export csv or insert statements along with the create table DDL?

TIA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-12 : 13:08:30

SQL Server 6.5's Enterprise Manager has a "Generate SQL script" wizard that will allow you to generate the schema script. You can then use bcp.exe to export the data to csv files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources