Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
White 0rchid
EVE University Ivy League
8
|
Posted - 2015.06.17 12:33:51 -
[1] - Quote
Alright so, I require the SDE as I want to make an ASP.NET web application for the analysing of market data and so on.
So I'm running MSSQL Server 2014, I can import the ebs_DATADUMP into a separate database just fine.
I have my own database, lets just call it EVETRADE for now.
How does everyone else cope with this, do you all run two separate databases? One with your own tables etc and the other will each new SDE dump that CCP provides? Or do you try and maintain a single database? Only issue I had with this is that trying to 'restore' from the backup would just wipe all my other tables from the database instead of just copy the data in (I'm not massively used to SQL server).
I intend on building entity models up for this as well.
Any advice is much appreciated. |
Desmont McCallock
427
|
Posted - 2015.06.17 14:20:53 -
[2] - Quote
Keep the app DB separate from the EVE SDE. |
White 0rchid
EVE University Ivy League
8
|
Posted - 2015.06.17 16:36:24 -
[3] - Quote
Thanks, so I'd just be restoring the .bak file each time and refreshing my entity model against it, assuming they keep it roughly the same design? |
Desmont McCallock
429
|
Posted - 2015.06.17 19:47:02 -
[4] - Quote
This tool will try to compensate on any changes made to the SDE. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5369
|
Posted - 2015.06.18 11:41:35 -
[5] - Quote
Keeping them separate is the way to go. Couple of reasons: A: backing up the data from CCP is pointless and a waste of space, when you can just reimport it. B: updating it is far less painful.
What you might want to consider is synonyms, so it all /appears/ to be in your own database.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1638
|
Posted - 2015.06.18 21:00:31 -
[6] - Quote
I build my own DB to save space and create my own tables (without massive queries and links). I then built an updater program that copies user saved data to the "fresh" version after patch updates. I seldom use the SDE database other than building my own. SQLite is a much easier format to work with for me than mssql.
But I don't do web apps so not sure how useful that is to you.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Mr Mac
Dark Goliath
69
|
Posted - 2015.06.18 21:14:24 -
[7] - Quote
Yeah separate DBs is best way.
You can also use SQL Server Import and Export Wizard to copy tables if you prefer to have one DB |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |