Exporting a MS-SQL database

I have an asp site connected to an MS-SQL database, I need to export
the database and import it in to a MySQL database? How would I be able
to do this? My only way of communicating with the MS-SQL database is
via asp scripts.

Thank You
Ben Sagal

PS. i have no problem fixing the SQL code manually to be compatible
with MySQL.TI know you only have access via an asp script , but MySQL do offer a
migration toolkit

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
<bsagal@.gmail.comwrote in message
news:1191321416.670361.48860@.50g2000hsm.googlegrou ps.com...

Quote:

Originally Posted by

>I have an asp site connected to an MS-SQL database, I need to export
the database and import it in to a MySQL database? How would I be able
to do this? My only way of communicating with the MS-SQL database is
via asp scripts.
>
Thank You
Ben Sagal
>
PS. i have no problem fixing the SQL code manually to be compatible
with MySQL.
>

Export tables to csv file

Hi...

I have 4 connected table in sql, and i have view that query this 4 and create 1 table, can i export that to csv file?

thank you...

Once you have the SELECT written, export is quit easy. See http://www.codeproject.com/aspnet/Excel_CSV_export_button.asp An extended ASP.NET button control for exporting/downloading Excel or CSV file.

|||

Yes, you can!

How? By using DTS in SQL Server 2000 or SSIS in SQL Server 2005.

Justright click on the database and select "Tasks" then "Export".

Decide yoursource (your sql server andyour databasethat you are working on) then decide about yourdestination selectFlat File Destination from the drop down menu.

Click onBrowse, select your destination .cvs file.

Tip: You maycheck the box tomake table's columns in the first line of the .cvs file.

Select theFormat: (for example: Delimited)

Select theText Qualifier: (for example " or ' depends on your case).

Click onNext.

Now you can either to get dump thefull data in the table into the .cvs fileby selecting thefirst option,

OR

you may getpart of the data and dumpt it into the .cvs file by selecting thesecond option.

Click onNext.

Specify thesource Table OR View from the drop down menu. (usually you don't need to change the values of the others two drop down menues).

Click onNext, thenFinished.

We areDONE!

I hope this steps will solve the issue.

Regards,
CS4Ever

-------------

If you find this post useful & helpful, please click on "Make as Answer" button.