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.
 

SDE MSSQL Database Best Methods/Practices

First post
Author
Previous Topic Next Topic
White 0rchid
V0LTA
New Eden Alliance 99013733
#1 - 2015-06-17 12:33:51 UTC
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
#2 - 2015-06-17 14:20:53 UTC
Keep the app DB separate from the EVE SDE.
White 0rchid
V0LTA
New Eden Alliance 99013733
#3 - 2015-06-17 16:36:24 UTC
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
#4 - 2015-06-17 19:47:02 UTC
This tool will try to compensate on any changes made to the SDE.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-06-18 11:41:35 UTC
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 XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zifrian
The Frog Pond
Ribbit.
#6 - 2015-06-18 21:00:31 UTC
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.

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

Import CCP's SDE - EVE SDE Database Builder
Mr Mac
Dark Goliath
#7 - 2015-06-18 21:14:24 UTC
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