open All Channels
seplocked EVE Technology Lab
blankseplocked MSSQL to MySQL convert - What to use?
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

The Offerer
Minmatar
Posted - 2011.07.30 07:27:00 - [1]
 

My project came to the point where I'll need SQL data dump in order to continue developing. I already have Apache/PHP/MySQL installed (Windows 7 64bit) but I'm not that skilled with MS products (or willing to pay for them).

I know that there are players that provide MySQL conversions, but thought to try to do it myself. After searching for a while for an appropriate tool, I've only found commercial solutions that can do this. So, my question is:

Is there an opensource/freeware solution that can import CCP's data dump (.sql and .bak files) and convert it to MySQL?
OR
Could I just use SQL express to convert the database to MySQL? (not experienced enough with MSSQL Embarassed)

Managing and viewing the database can be done with Navicat Lite (free version), but it can't load the data (only create tables) and it can't convert the database to MySQL (only commercial version can do it). "Alternative" sources for getting the full version is not an option.

Thanks.

Flaming Candle
Posted - 2011.07.30 09:24:00 - [2]
 

3rd party database conversions

3rd party documentation of the data dump

'Official' API documentation

Or you could have read the 5 sticky threads in which all of these are linked rather then creating a new thread about it.


Desmont McCallock
Posted - 2011.07.30 10:03:00 - [3]
 

@Flaming Candle
Originally by: The Offerer

I know that there are players that provide MySQL conversions, but thought to try to do it myself.

He clearly states that he knows that but what I get from the OP is that he likes to be independent from 3rd party conversions.

@The Offerer
I had too looked up for that possibility but couldn't find any free/shareware software.
I ended up with Navicat Premium (after a friend suggested it).

Alkathron
Posted - 2011.08.01 08:43:00 - [4]
 

Edited by: Alkathron on 01/08/2011 08:48:20
Why do you need to convert it ?
The data-dump is for mysql and sqlite too...
http://eve.no-ip.de/inca10/

Aren't them the same dump ?

bye


Elmore Jones
Electric Monk inc
Redrum Fleet
Posted - 2011.08.01 18:20:00 - [5]
 

The trunk source of EveHQ includes db conversions, see forums at evehq.battleclinic.com :)


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only