From MySql To MSSQL And a Synchronize structure tool

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PadovaBoy (ovvero Giovanni) - 16 Jul 2008 08:33 GMT

Hi at all!

I need a tool to migrate my huge database (structure and data) from
MySql to MSSQL Express (after 4 years now i hate mysql).
I don't want to pay much ;)

I need another tool: one for Synchronize structure of 2 tables...and
another time: i'm not rich :P

Thank u very much and i'm sorry for my english ;)

Reply to this Message

Ekrem Önsoy - 15 Jul 2008 15:51 GMT

> I need a tool to migrate my huge database (structure and data) from MySql
> to MSSQL Express

Are you aware of the database size limit of SQL Server 2005 Express Edition?
I don't exactly know what you mean by saying "huge" but you are limited with
4GB database size in Express Edition of SQL Server 2005.

And for migration, you may want to check out the following White Paper about
migrating from MySQL to SQL Server 2005
http://www.microsoft.com/sql/techinfo/whitepapers/MigrateMySQL.mspx

Signature

Ekrem Önsoy

> Hi at all!
>
[quoted text clipped - 6 lines]
>
> Thank u very much and i'm sorry for my english ;)

Reply to this Message

PadovaBoy (ovvero Giovanni) - 16 Jul 2008 10:22 GMT

Ekrem Önsoy ha scritto:

>> I need a tool to migrate my huge database (structure and data) from
>> MySql to MSSQL Express
[quoted text clipped - 6 lines]
> about migrating from MySQL to SQL Server 2005
> http://www.microsoft.com/sql/techinfo/whitepapers/MigrateMySQL.mspx

Thank u very much for your reply!
I know this document and it's very useful! But there aren't any
suggestion for migrate the data.

Yes i know the limitation and effectively my database is not very huge
for memory (150MB) but I have a large number of tables and indexes -> i
don't want to do the work with hand :)

There isn't any tool for do that clean?

Reply to this Message

Ekrem Önsoy - 16 Jul 2008 12:39 GMT

I think you are looking for a tool which is just like MySQL' s Migration
Tool.

Sorry, I don't know such a tool to migrate from MySQL to SQL Server.

Signature

Ekrem Önsoy

> Ekrem Önsoy ha scritto:
>>> I need a tool to migrate my huge database (structure and data) from
[quoted text clipped - 17 lines]
>
> There isn't any tool for do that clean?

Reply to this Message

PadovaBoy (ovvero Giovanni) - 16 Jul 2008 12:46 GMT

Ekrem Önsoy ha scritto:

> I think you are looking for a tool which is just like MySQL' s Migration
> Tool.
>
> Sorry, I don't know such a tool to migrate from MySQL to SQL Server.

Ok no prob, thank u very much ;)

Reply to this Message

Siim Karus - 16 Jul 2008 16:27 GMT

Hi!

I tried Data Doctor MySQL to MSSQL converter a while ago (
http://www.datadoctor.org/partition-recovery/mysql-mssql-converter.html ).
It requires you to have both databases running at the same time and it was
not able to convert everything, but it still did a lot.

Yours sincerely,
Siim Karus

> Hi at all!
>
[quoted text clipped - 6 lines]
>
> Thank u very much and i'm sorry for my english ;)

Reply to this Message

Jean-Pierre Gutsatz (DMC) - 17 Jul 2008 13:01 GMT

Hello,

Why don't you try out DMC for the jobs ?
Cloning is possible
Transfering is possible
Synching we are working on it right now and it will be available in the next
version :)

www.dmc-fr.com

let me know if I can help more

Signature

Thank you

Cordialement - Best regards
Jean-Pierre GUTSATZ

CGF
32 Rue Jean Moulin
34 630 Saint-Thibéry
Tel : (33) 467 322 167
Fax : (33) 1 5301 4749

DMC - Data Management Center - A tool to let you Migrate Import Export
Transfer all your Data very easily
www.dmc-fr.com cgf@dmc-fr.com
Certified by Microsoft : "Works with Vista" & "Works with Windows Server
2008"

> Hi at all!
>
[quoted text clipped - 6 lines]
>
> Thank u very much and i'm sorry for my english ;)

Reply to this Message