DevForce Community Forum : Convert Mysql to MSSQL http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Convert Mysql to MSSQL Wed, 10 Jun 2026 12:28:23 -700 Fri, 05 Mar 2010 05:05:30 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=957 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Convert Mysql to MSSQL : DBConvert tool is able to convert... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6302#6302 Author: dmsoft
Subject: 957
Posted: 05-Mar-2010 at 5:05am

DBConvert tool is able to convert from Mysql to MSSQL. For more information take a look at http://www.dbconvert.com/convert-mssql-to-http://www.dbconvert.com/convert-mssql-to-mysql-pro.php

Edited by dmsoft - 05-Mar-2010 at 5:08am]]> Fri, 05 Mar 2010 05:05:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6302#6302 Convert Mysql to MSSQL : DevForce WinClient and DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6160#6160 Author: davidklitzke
Subject: 957
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/
 
There may be other providers as well, either now or in the future.  Try searching the web for "MYSQL Entity Framework".
]]> Tue, 02 Feb 2010 09:24:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6160#6160 Convert Mysql to MSSQL : Which devforce product support... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6158#6158 Author: vinothvdp
Subject: 957
Posted: 01-Feb-2010 at 9:31pm

Which devforce product support MYSQL?]]> Mon, 01 Feb 2010 21:31:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6158#6158 Convert Mysql to MSSQL : IdeaBlade does not officially... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6157#6157 Author: davidklitzke
Subject: 957
Posted: 01-Feb-2010 at 10:30am

IdeaBlade does not officially support MySQL for DevForce Classic.  Please review other posts from this thread.]]> Mon, 01 Feb 2010 10:30:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6157#6157 Convert Mysql to MSSQL : Greets, How to use MYSQL database?,... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6156#6156 Author: vinothvdp
Subject: 957
Posted: 31-Jan-2010 at 6:09am

Greets,
How to use MYSQL database?, is there any example available? please help me out..

Thanks]]> Sun, 31 Jan 2010 06:09:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=6156#6156 Convert Mysql to MSSQL : Use a tool to migrate database,... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5954#5954 Author: Shumaker212
Subject: 957
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]]> Fri, 18 Dec 2009 03:24:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5954#5954 Convert Mysql to MSSQL : Originally posted by DjStitchCan... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5822#5822 Author: mesothelioma claims
Subject: 957
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?


Edited by mesothelioma claims - 17-Nov-2009 at 9:05pm]]> Tue, 17 Nov 2009 21:02:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5822#5822 Convert Mysql to MSSQL : Here is a tool to convert MSSQL... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5281#5281 Author: jean3167
Subject: 957
Posted: 31-Aug-2009 at 2:48am

Here is a tool to convert 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.]]> Mon, 31 Aug 2009 02:48:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5281#5281 Convert Mysql to MSSQL : I use data loader for migrating... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5213#5213 Author: wonn1377
Subject: 957
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

]]> Fri, 21 Aug 2009 07:04:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=5213#5213 Convert Mysql to MSSQL : Can you please check my other... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3459#3459 Author: DjStitch
Subject: 957
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 

]]> Fri, 03 Oct 2008 05:12:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3459#3459 Convert Mysql to MSSQL : You may certainly setup the relations... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3457#3457 Author: davidklitzke
Subject: 957
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.]]> Thu, 02 Oct 2008 08:16:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3457#3457 Convert Mysql to MSSQL : Thanks for you reply...... I realy... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3455#3455 Author: DjStitch
Subject: 957
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.

 

 

 

 

 

 

 

]]> Wed, 01 Oct 2008 23:28:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3455#3455 Convert Mysql to MSSQL : Only INNODB type MSQL Databases... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3454#3454 Author: davidklitzke
Subject: 957
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.
]]> Wed, 01 Oct 2008 15:50:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3454#3454 Convert Mysql to MSSQL : Hi there ..... I need some... http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3453#3453 Author: DjStitch
Subject: 957
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.......  
]]> Wed, 01 Oct 2008 05:07:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=957&PID=3453#3453