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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Exporting Data

Author  Topic 

priyadarshee
Starting Member

5 Posts

Posted - 2010-12-04 : 02:37:13
How will export data from a database in sqlserver 2005 in sql format so that I can import in mysql ?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-05 : 13:12:07
>> in sql format?
Try using bcp or ssis to export to a csv or such like file then import.
Otherwise you should be able to create an odbc connection t mysql and use it in ssis to insert.
Could probably also use a linked server.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -