Solved

Export from MSSQL and import to MYSQL

Posted on 2015-02-24
3
177 Views
Last Modified: 2015-02-26
I need to export tables from my windows server 2008R2 MSSQL 2008 and import to my linux server MYSQL.
0
Comment
Question by:Jose Bredariol
3 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 250 total points
ID: 40629268
0
 
LVL 48

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40633417
You can use the Import/Export feature in SSMS. You'll need to have the MySQL client installed on the SQL Server machine.
Open SSMS and right-click on the source database name then Tasks / Export data... and follow the wizard.
TaskMenu.PNG
0
 

Author Closing Comment

by:Jose Bredariol
ID: 40633483
Thanks all
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question