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.
Previous page12
 

Building an SDE To xSQL conversion tool - Completed

First post
Author
Previous Topic Next Topic
Desmont McCallock
#21 - 2015-11-03 17:29:13 UTC
I will attempt to work on producing an MySQL dump file for MySQL 5.7. Is that OK with you ppl?
Desmont McCallock
#22 - 2015-11-05 12:41:23 UTC
There will be a slight delay cause I totally forgot indexing (something that is not done in the current version of tool either).
Desmont McCallock
#23 - 2015-11-06 09:42:06 UTC
Anyone with more knowledge on MySQL than me please feel free to help out.

In my attempt to produce a MySQL dump script file of the SDE residing in an SQL Server instance, I'm faced with the decision of proper data type usage for numeric types in MySQL.

I have gone with the following choices:

MSSQL | MySQL
bigint => bigint(20) unsigned
int => int(10) unsigned
smallint => smallint(6) unsigned
tinyint => tinyint(3) unsigned
bit => bit
float => double unsigned
real => double unsigned
double => double unsigned
money => decimal(15,2) unsigned

I would really like your insights on my above choices.

Thanks in advance.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#24 - 2015-11-06 12:17:30 UTC
I'd suggest using signed integers in general. valueInt, in dgmTypeAttributes required negative numbers, for example.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#25 - 2015-11-06 13:01:26 UTC  |  Edited by: Desmont McCallock
Steve Ronuken wrote:
I'd suggest using signed integers in general. valueInt, in dgmTypeAttributes required negative numbers, for example.
I knew that someone would say that but I prefer to use unsigned unless I have to use signed in specific columns.

@Steve
Edit: Come to think of it again, I'll consider your advice. Maybe I end up following it.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#26 - 2015-11-06 18:17:48 UTC
If you're not going with a flat mapping, but can override for specific, it's fine :D

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#27 - 2015-11-06 18:25:43 UTC
The safest approach would be to have all IDs as unsigned (except the one in warcombatsomthing table which has -1 set as default) and have all other columns as signed.
Desmont McCallock
#28 - 2015-11-09 14:28:59 UTC
Links of the dumps that the tool creates have been added in first post.

I would really appreciate if you try them out and give me feedback.
Desmont McCallock
#29 - 2015-11-11 13:01:39 UTC
Ability to export to MS Access database file added.
Desmont McCallock
#30 - 2015-11-15 12:35:57 UTC
Project completed. Official release will follow in separate thread.
Previous page12