SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Exporting Data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

priyadarshee
Starting Member

5 Posts

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

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 12/05/2010 :  13:12:07  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
>> 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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.86 seconds. Powered By: Snitz Forums 2000