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.
| Author |
Topic |
|
priyadarshee
Starting Member
5 Posts |
 Posted - 2010-12-04 : 02:38:24
|
| How will export data from a database in sqlserver 2005 in sql format so that I can import in mysql ? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-04 : 12:39:57
|
| You can do any of the following:- Use data export wizard- use SSIS.- Create a linked server and use T-SQL INSERT/SELECT FROM statement- BCP the data out from mssql and import to mySQL- Script T-SQL INSERT statements for all of the rows in the tables you want to export, then run them against mySQL. |
 |
|
|
sebekz
Starting Member
5 Posts |
Posted - 2010-12-06 : 03:38:18
|
| Have you read MySQL doc? See [url]http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html[/dev], as you might run into various issues as well.================================================================Organize you SQL Serverwith a smart Management Studio PluginSQL Handy Groupie SSMS Add-In[url]www.skilledsoftware.com[/url]Create custom folders and group databases, tables, views, procedures, UDFsextending native SSMS functionality================================================================ |
|
|
|
|
|
|
Exporting Data