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.
 

Frostline SDE conversions

First post
Author
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2015-12-07 12:55:09 UTC
Desmont McCallock
#2 - 2015-12-07 13:01:42 UTC  |  Edited by: Desmont McCallock
And not to forget that you can make your own dumps in your favorite format with EVESDEToSQL.

Notice: The produced dumps are not compatible with Steve's.
Airi Cho
Dark-Rising
Wrecking Machine.
#3 - 2015-12-07 14:36:51 UTC
so we need a steve compat mode for EVESDEToSQL ;)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-12-07 17:27:13 UTC
Airi Cho wrote:
so we need a steve compat mode for EVESDEToSQL ;)



Well, you could always use https://github.com/fuzzysteve/SDE-loaders Blink to populate an SQL server DB.

I'm considering putting in a 'convert to other formats' program in there, but it would likely lead to slightly different schema layouts, which leaves me a touch wary.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Medusa The Gorgon
Temple of the Serpent
The Gorgon Empire
#5 - 2015-12-08 21:41:55 UTC  |  Edited by: Medusa The Gorgon
I've noticed that ‘Micro' Remote Shield Booster lost first ' . Is official dump contains tha same?

edit: Ahh, they are yamls now. Yes, official data lacks '
Airi Cho
Dark-Rising
Wrecking Machine.
#6 - 2015-12-09 01:18:04 UTC  |  Edited by: Airi Cho
file postgres-frostline-1.0-116241-schema.sql.bz2
postgres-frostline-1.0-116241-schema.sql.bz2: gzip compressed data, from Unix


it is actually compressed twice. inside is bzip2 then.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2015-12-09 13:04:07 UTC
Airi Cho wrote:
file postgres-frostline-1.0-116241-schema.sql.bz2
postgres-frostline-1.0-116241-schema.sql.bz2: gzip compressed data, from Unix


it is actually compressed twice. inside is bzip2 then.



It's a pgdump file (which has gzip compression) which was then bzip2ed (to get round an issue my webserver has with gzipped data. namely, telling your browser, which then uncompresses it before storing it)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter