These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Is there a tool to convert the mssql db structure to sqlite or postgres?
Author
Previous Topic Next Topic
Nomad I
University of Caille
Gallente Federation
#1 - 2012-08-30 19:04:05 UTC
I don't like manual operations and looked into the mssql db. I know to handle sqlite and postgres, but not mssql express very well. The task is to read out the database structure and data with python and write some tables back into another db like mysql or sqlite. I'm able to read tables with python from mssql express but more advanced ops like getting the structure of a db is a problem.

The problem:
How can I read out the db structure from mssql express 2012?


Has someone a tip?
Benign Sage
Republic University
Minmatar Republic
#2 - 2012-08-30 19:26:31 UTC  |  Edited by: Benign Sage
A useful tool for managing MSSQL databases is called SQL Management Studio. See below for downloads:

http://www.microsoft.com/en-us/download/details.aspx?id=29062

As far as converting a database from MSSQL to Postgre you can try below:

http://www.dbconvert.com/convert-mssql-to-postgre-pro.php?DB=6

Another one here (little cheaper):

http://www.dbelephant.com/MSSQL2Postgre

Costs money :( But in my quick search I couldn't find anything I would trust that didn't.

I hope this helps!

Sage

[u]My EVE API [/u] https://www.myeveapi.com
Nomad I
University of Caille
Gallente Federation
#3 - 2012-08-30 21:05:19 UTC  |  Edited by: Nomad I
There must be a way to read out the system catalogs from mssql express. I have the management studio but searching in 4 system db's isn't fun.
Nomad I
University of Caille
Gallente Federation
#4 - 2012-08-31 06:03:17 UTC
I found something like a systemcatalog in db for the static eve data. Big smile
Peter Powers
Terrorists of Dimensions
HORSE-KILLERS
#5 - 2012-08-31 08:28:10 UTC
there is already someone providing dumps in several variants.

dumps(mysql and postgre)

3rdPartyEve.net - your catalogue for 3rd party applications
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-08-31 10:05:55 UTC
There's also
[shameless promotion]
http://www.fuzzwork.co.uk/dump/
[/shameless promotion]

No postgresql dumps, but there is a sqlite one. (and mysql.)

specifically
http://www.fuzzwork.co.uk/dump/inferno12/inferno12.sqlite.bz2


I try to get the conversion done shortly after the release happens. usually within a few hours. Depends on when it happens and how busy I am at work Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Nomad I
University of Caille
Gallente Federation
#7 - 2012-08-31 23:34:30 UTC
Thank you!