Print Page | Close Window

Convert Mysql to MSSQL

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=957
Printed Date: 28-Mar-2024 at 6:16am


Topic: Convert Mysql to MSSQL
Posted By: DjStitch
Subject: Convert Mysql to MSSQL
Date Posted: 01-Oct-2008 at 5:07am
Hi there .....
 
I need some advice.
 
One of my clients wants to move about 200 users to MSSQL.
Now to problem that I have is all of them is on "MYSQL" and what I noted is that there mysql database design has got not "RELATIONS" between them.
 
Now i can redesign a new MSSQL databas to use "RELATIONS' but how do I convert all the 200 users to the new MSSQL database becourse there MYSQL databases got no "RELATIONS".
 
I got a cople of convert programs but it won't help me if the MYSQL desighn dont have relations to start off - so the relations wont be converted.
 
Thanks.......  



Replies:
Posted By: davidklitzke
Date Posted: 01-Oct-2008 at 3:50pm
Only INNODB type MSQL Databases support relations. So you have to make all your tables INNODB to support relations.
 
InnoDB provides MySQL with a transaction-safe (ACID compliant) storage engine that has commit, rollback, and crash recovery capabilities. InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in SELECT statements. These features increase multi-user concurrency and performance. There is no need for lock escalation in InnoDB because row-level locks fit in very little space. InnoDB also supports FOREIGN KEY constraints. You can freely mix InnoDB tables with tables from other MySQL storage engines, even within the same statement.


Posted By: DjStitch
Date Posted: 01-Oct-2008 at 11:28pm

Thanks for you reply...... I realy did not know that.

I went trough your whitepapers and a saw the you can setup manual relations between tables.

My second question is --->

I am stil using version 3.x, so I will convert all the users with a convert utility to MSSQL, then setup manual relations useing Object Mapper..

Will this work and how many relations can be mapped to one table for example ?

I got a table "cust_main" with all the customers in about 23000, now all of the got relations tables

"cust_address" - home address

"cust_masdep - dependants to the cust main and so on.

How long will a query to the database take ?

Thanks.

 

 

 

 

 

 

 



Posted By: davidklitzke
Date Posted: 02-Oct-2008 at 8:16am
You may certainly setup the relations using the Object Mapper, but I would prefer that you build the relations in the in the MSSQL database instead.  Otherwise. you willl need to manually create the relations in the Object Mapper every time that you create a solution using these tables.


Posted By: DjStitch
Date Posted: 03-Oct-2008 at 5:12am

Can you please check my other thread - not this one.

With the other thread I explain everything in detail 



Posted By: wonn1377
Date Posted: 21-Aug-2009 at 7:04am

I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool 


Download Free : http://www.dbload.com - http://www.dbload.com



Posted By: jean3167
Date Posted: 31-Aug-2009 at 2:48am
Here is a tool to convert http://www.convert-db.com/mssql-to-mysql.htm - MSSQL to MYSQL database. That i found on google search it this converter can do migrate any data try and tel me is that worth or not.


Posted By: mesothelioma claims
Date Posted: 17-Nov-2009 at 9:02pm
Originally posted by DjStitch

Can you please check my other thread - not this one.

With the other thread I explain everything in detail 



Hey where is your other thread?


-------------
http://www.1stclaims.co.uk/asbestos-claim/mesothelioma-claims.php - mesotheliomaclaim | http://www.1stclaims.co.uk/asbestos%20claim/mesothelioma-claims.php - asbestos mesothelioma claims


Posted By: Shumaker212
Date Posted: 18-Dec-2009 at 3:24am
Use a tool to migrate database, i use dbload for the conversion of database.

Find Here :  http://www.dbload.com


Posted By: vinothvdp
Date Posted: 31-Jan-2010 at 6:09am
Greets,
How to use MYSQL database?, is there any example available? please help me out..

Thanks


Posted By: davidklitzke
Date Posted: 01-Feb-2010 at 10:30am
IdeaBlade does not officially support MySQL for DevForce Classic.  Please review other posts from this thread.


Posted By: vinothvdp
Date Posted: 01-Feb-2010 at 9:31pm
Which devforce product support MYSQL?


Posted By: davidklitzke
Date Posted: 02-Feb-2010 at 9:24am
DevForce WinClient and DevForce Silverlight.
 
There is a provider from Devart that has MYSQL support for the Entity Framework.  If a provider works with the Entity Framework, it will work with DevForce WinClient or DevForce Silverlight.  See:

http://www.devart.com/dotconnect/mysql/ - http://www.devart.com/dotconnect/mysql/
 
There may be other providers as well, either now or in the future.  Try searching the web for "MYSQL Entity Framework".


Posted By: dmsoft
Date Posted: 05-Mar-2010 at 5:05am
http://dbconvert.com - DBConvert tool is able to convert from Mysql to MSSQL. For more information take a look at http://www.dbconvert.com/convert-mssql-to-mysql-pro.php - http://www.dbconvert.com/convert-mssql-to-http://www.dbconvert.com/convert-mssql-to-mysql-pro.php



Print Page | Close Window