Convert SQL Server schema & Data to Import to MYSQL db.

Question

Convert SQL Server schema & Data to Import to MYSQL db.

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
July 25, 2017 at 11:07 am

#402359

Hi,
I want to create my maintenance script and the corresponding data entry to a MYSQL Database. Is there any tool which converts the data type and other script to load properly to MS SQL? Pl suggest
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246965 More actions · Answer 1

SQL-DBA-01 - Tuesday, July 25, 2017 11:07 AM
Hi,
I want to create my maintenance script and the corresponding data entry to a MYSQL Database. Is there any tool which converts the data type and other script to load properly to MS SQL? Pl suggest

You are converting to MySQL, but you want it to load in MS SQL â€“ you seem to be going in two directions here. What does your 'maintenance script' maintain?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Want to convert SQL Server Scripts (functions, procs, triggers and related scripts) from MS SQL DB to MYSQL. These scripts are used for general DB maintenance purposes , say checkdb integrity, bkp/restore/ rebuild index/stats and so on.

Thanks.

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

SQL-DBA-01 - Tuesday, July 25, 2017 12:22 PM
Want to convert SQL Server Scripts (functions, procs, triggers and related scripts) from MS SQL DB to MYSQL. These scripts are used for general DB maintenance purposes , say checkdb integrity, bkp/restore/ rebuild index/stats and so on.

Not that I know of. Perhaps you could try raising this on a MySQL forum.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Lowell SSC Guru Points: 323518 More actions · Answer 4

tables and views are easyto convert, but procedures that do stuff meta-data wise will require a complete re-write.
checkdb? kind of equivalents are CHECK TABLE , REPAIR TABLE , ANALYZE TABLE
reindex? backup and reswtore, similar enough that maybe you could find/replace, ior use as is, but there's a learning curve in there for sure.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

nerdCat SSC Eights! Points: 859 More actions · Answer 5

I am in the middle of something similar with an app I am building. Your maintenance on SQL Server will not be handled the same on MySQL...SSC guru mentions this. Concepts will be similar, but implementation will be different.