Solved

Export from MSSQL and import to MYSQL

Posted on 2015-02-24
3
169 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 61

Accepted Solution

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

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
XML to SQL Table using c# 5 47
MySQL ERROR 1045 (28000) 2 41
Retention Policy for Backups 1 13
select over clause 1 0
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now