| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Nomad I
University of Caille
Gallente Federation
118
   |
Posted - 2012.08.30 19:04:00 -
[1] - Quote
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
Rock Ballz INC.
13
|
Posted - 2012.08.30 19:26:00 -
[2] - Quote
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 |
Nomad I
University of Caille
Gallente Federation
118
|
Posted - 2012.08.30 21:05:00 -
[3] - Quote
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
118
|
Posted - 2012.08.31 06:03:00 -
[4] - Quote
I found something like a systemcatalog in db for the static eve data.  |
Peter Powers
Terrorists of Dimensions
Free 2 Play
88
|
Posted - 2012.08.31 08:28:00 -
[5] - Quote
there is already someone providing dumps in several variants.
dumps(mysql and postgre)
|
Steve Ronuken
Fuzzwork Enterprises
610
|
Posted - 2012.08.31 10:05:00 -
[6] - Quote
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 
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Nomad I
University of Caille
Gallente Federation
118
|
Posted - 2012.08.31 23:34:00 -
[7] - Quote
Thank you! |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |