From MySql To MSSQL And a Synchronize structure tool

Ekrem Önsoy ha scritto:
>> 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
>

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?
 >> Stay informed about: From MySql To MSSQL And a Synchronize structure tool 

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.

--
Ekrem Önsoy



"PadovaBoy (ovvero Giovanni)" wrote in message

> Ekrem Önsoy ha scritto:
>>> 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
>>
>
> 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?
>
 >> Stay informed about: From MySql To MSSQL And a Synchronize structure tool 

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
 >> Stay informed about: From MySql To MSSQL And a Synchronize structure tool 

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

"PadovaBoy (ovvero Giovanni)" kirjutas sõnumis
487da44c$0$18148$4fafbaef@reader3.news.tin.it...
> 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
>
> Thank u very much and i'm sorry for my english
 >> Stay informed about: From MySql To MSSQL And a Synchronize structure tool 

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

--
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.RemoveThis@dmc-fr.com
Certified by Microsoft : "Works with Vista" & "Works with Windows Server
2008"

"PadovaBoy (ovvero Giovanni)" a écrit dans le
message de 487da44c$0$18148$4fafbaef@reader3.news.tin.it...
> 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
>
> Thank u very much and i'm sorry for my english
>
 >> Stay informed about: From MySql To MSSQL And a Synchronize structure tool