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
 

EVE SDE Database Builder

First post
Author
Previous Topic Next Topic
Fey Dekill
Science and Trade Institute
Caldari State
#21 - 2017-02-12 19:30:09 UTC
Just a thought: If ever there is a change in the SDE data (meaning, in the case it is not so _static_ ie not SDE but NSSDE ;) ), and we want to reload all the files, does it handle duplicates, or do we need to import them files in another database, then make the switch... (ie: what (is supposed to ) happens if I run the import twice in a row?)
Zifrian
Federal Defense Union
Gallente Federation
#22 - 2017-02-12 21:21:31 UTC
Fey Dekill wrote:
Just a thought: If ever there is a change in the SDE data (meaning, in the case it is not so _static_ ie not SDE but NSSDE ;) ), and we want to reload all the files, does it handle duplicates, or do we need to import them files in another database, then make the switch... (ie: what (is supposed to ) happens if I run the import twice in a row?)

The import will drop the current table and reload it with new data. If you want to just update one table, you can select the one and do it that way.

The SDE is updated every patch, so you'll have to run the update each time they release it to get changes.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Athlonman
The Executives
#23 - 2017-02-22 05:37:28 UTC
Testing on Windows 10 host and a MSSQL Server running in a Virtual Machine (Virtual Box, SLES 12, vNext CTP 1.3) I noticed that the app was defaulting to HOSTNAME/Guest for login even though I specified the USERNAME and PASSWORD to use. Does the app support SQL Server Authentication or does it stick with Windows Authentication? As a work around I created the user it was trying to use in SQL Server and gave that user full rights for the import. So far so good, I will just have to remove those rights when the import is done.
Zifrian
Federal Defense Union
Gallente Federation
#24 - 2017-02-26 02:34:12 UTC  |  Edited by: Zifrian
Athlonman wrote:
Testing on Windows 10 host and a MSSQL Server running in a Virtual Machine (Virtual Box, SLES 12, vNext CTP 1.3) I noticed that the app was defaulting to HOSTNAME/Guest for login even though I specified the USERNAME and PASSWORD to use. Does the app support SQL Server Authentication or does it stick with Windows Authentication? As a work around I created the user it was trying to use in SQL Server and gave that user full rights for the import. So far so good, I will just have to remove those rights when the import is done.

Ahh yeah, it does. If you can give me some instances on how you use it I'll try and set up some test cases. I just have the express version installed on my local computer so I'm not sure of all the options.

Edit: I looked back at the code and I'm not sure why it would default to Guest. Here is the code with my connection strings:

' Log in with user name and pass
Conn = New SqlConnection(String.Format("Server={0};User Id={1};Password={2};Trusted_Connection=True; Initial Catalog=master; Integrated Security=True;Connection Timeout=30;", InstanceName, UserName, Password))

' Use windows default connection (windows authentication)
Conn = New SqlConnection(String.Format("Server={0};Trusted_Connection=True; Initial Catalog=master; Integrated Security=True;Connection Timeout=30;", InstanceName))


Neither uses the environment variable anymore and allows the user to define the full instance path. If you have any input on the above, I'd appreciate it.

Thanks

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Sariel Kusoni
KarmaFleet
Goonswarm Federation
#25 - 2017-04-14 17:03:41 UTC
i just tried to import the universe data into a mysql database.

it imports every single file and creates all tables, rows, etc. but it only sets the values of the first row of every table (mostly id's). all other values in rows other than the first get NULL as value.

idk if this is a bug or if i am just not smart enough to use the tool ... but it would be cool if you could look into this problem for me :)

thx o7

(and no, it's not just with map data. other types have the same problem i think)
Zifrian
Federal Defense Union
Gallente Federation
#26 - 2017-04-15 01:56:56 UTC
Sariel Kusoni wrote:
i just tried to import the universe data into a mysql database.

it imports every single file and creates all tables, rows, etc. but it only sets the values of the first row of every table (mostly id's). all other values in rows other than the first get NULL as value.

idk if this is a bug or if i am just not smart enough to use the tool ... but it would be cool if you could look into this problem for me :)

thx o7

(and no, it's not just with map data. other types have the same problem i think)

I just ran it from scratch and no issues. How are you connecting? Is this a local host or a network server? I'm testing using a local host.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Sariel Kusoni
KarmaFleet
Goonswarm Federation
#27 - 2017-04-15 14:25:27 UTC  |  Edited by: Sariel Kusoni
Quote:
just ran it from scratch and no issues. How are you connecting? Is this a local host or a network server? I'm testing using a local host.


it is a local hosted mysql db via xampp.

i just tried it with a sqlite db and it worked fine so i think i can work with that.
anyways thanks for your time :)
Previous page12