Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
m Light
I N E X T R E M I S Tactical Narcotics Team
0
|
Posted - 2016.03.10 15:38:01 -
[1] - Quote
o7
The DATADUMP201603090946.bak is missing type name data.
" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"
Is data schema change or I'm missing something.
|
Desmont McCallock
599
|
Posted - 2016.03.10 16:02:31 -
[2] - Quote
8 rows don't have typeName. 1 is an unpublished with description "Massive Environment". 7 are DUST 514 items, which are not critical for EVE Online. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5940
|
Posted - 2016.03.10 22:07:06 -
[3] - Quote
m Light wrote:o7
The DATADUMP201603090946.bak is missing type name data.
" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"
Is data schema change or I'm missing something.
Just checking, you know the official SDE stopped having type data in database export months ago? It's all in the yaml file now.
https://www.fuzzwork.co.uk/dump/yc118-3-117575/YC118-3-117575.bak.bz2 may be of interest if you didn't know. I've reimported the data back in. (7zip will uncompress the backup file)
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
m Light
I N E X T R E M I S Tactical Narcotics Team
0
|
Posted - 2016.03.16 20:47:36 -
[4] - Quote
Steve Ronuken wrote:m Light wrote:o7
The DATADUMP201603090946.bak is missing type name data.
" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"
Is data schema change or I'm missing something.
Just checking, you know the official SDE stopped having type data in database export months ago? It's all in the yaml file now. https://www.fuzzwork.co.uk/dump/yc118-3-117575/YC118-3-117575.bak.bz2 may be of interest if you didn't know. I've reimported the data back in. (7zip will uncompress the backup file)
O7 Many thanks for response and link.
I apologise in advance for using logic in this issue!
As IGÇÖm aware EVE is using SQL 2014 Enterprise as back end DB. The previous SQL backup includes item types and item groups.
Someone makes decision to export data from SQL to yame that is fine. The question is why exclude that data from SQL when it was there in the first place! I need to create component to import yaml back to SQL where it was in the first place.
IGÇÖm sure that someone from CCP can present business case that justifies that, and it goes blaaa blaaa blaaa.
m Light
|
Desmont McCallock
599
|
Posted - 2016.03.16 20:51:22 -
[5] - Quote
The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server. |
m Light
I N E X T R E M I S Tactical Narcotics Team
0
|
Posted - 2016.03.16 20:56:29 -
[6] - Quote
Desmont McCallock wrote:The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server.
Well I stated that is fine to export as yaml.
O7 Many thanks for response and link.
I apologise in advance for using logic in this issue!
As IGÇÖm aware EVE is using SQL 2014 Enterprise as back end DB. The previous SQL backup includes item types and item groups.
Someone makes decision to export data from SQL to yame that is fine. The question is why exclude that data from SQL when it was there in the first place! I need to create component to import yaml back to SQL where it was in the first place.
IGÇÖm sure that someone from CCP can present business case that justifies that, and it goes blaaa blaaa blaaa.
m Light |
m Light
I N E X T R E M I S Tactical Narcotics Team
0
|
Posted - 2016.03.16 22:41:54 -
[7] - Quote
Desmont McCallock wrote:The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server.
100% == 100 mil ISK ty |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5957
|
Posted - 2016.03.16 23:12:54 -
[8] - Quote
Should be noted:
The change happened a few months ago
The file I linked is an sql server backup file, which is fully integrated.
Converting it over is part of my process to create the other versions, so it'll stick around for a fair time. (Once it's entirely released in yaml, I may not. But that'd be because I could do the entire thing, without intervention, on my server. Which won't run sql server, until MS release an express edition on linux. Which I doubt will happen before 2017)
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
m Light
I N E X T R E M I S Tactical Narcotics Team
0
|
Posted - 2016.03.17 01:57:45 -
[9] - Quote
The short answer on how to get full MS SQL db not provided by CCP is https://forums.eveonline.com/default.aspx?g=posts&t=456458 |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5959
|
Posted - 2016.03.17 13:01:54 -
[10] - Quote
bad link?
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
Desmont McCallock
599
|
Posted - 2016.03.17 13:16:12 -
[11] - Quote
No. It's just the underlying url is malformed. The link is just the link to EVESDEToSQL forum thread.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |