Re: From MySql To MSSQL And a Synchronize structure tool
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.tools Profile…
 Up
Re: From MySql To MSSQL And a Synchronize structure tool         


Author: Ekrem Önsoy
Date: Jul 15, 2008 07:51

> 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

--
Ekrem Önsoy
Show full article (0.99Kb)
3 Comments
Re: From MySql To MSSQL And a Synchronize structure tool         


Author: PadovaBoy (ovvero Giovanni)
Date: Jul 16, 2008 02:22

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?
no comments
Re: From MySql To MSSQL And a Synchronize structure tool         


Author: Ekrem Önsoy
Date: Jul 16, 2008 04:39

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)" padovalandia.com> wrote in message
news:487dbdf1$0$18149$4fafbaef@reader3.news.tin.it...
> Ekrem Önsoy ha scritto:
>>> I need a tool to migrate my huge database...
Show full article (1.24Kb)
no comments
Re: From MySql To MSSQL And a Synchronize structure tool         


Author: PadovaBoy (ovvero Giovanni)
Date: Jul 16, 2008 04:46

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 ;)
no comments