EVE Search - Error reading SDE in SQL server 2008 express -can anyone help

All Channels

EVE Technology Lab

Error reading SDE in SQL server 2008 express -can anyone help

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
Pelorios Pelorios Industries 0	Posted - 2014.08.07 15:23:00 - [1] - Quote after reading http://phoenixdiaries.co.uk/eve-online-database-dump tried to restore the latest SDE (Crius 1.6 100370) through the sql server management studio but when i added the .bak file in the restore dialog i got the following error when clicking 'ok' : "Specified cast is not valid". There are is some additional info with the error: =================================== Specified cast is not valid. (SqlManagerUI) Program Location: at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.PopulateGridWithBackupSetsFromDevices() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.GetBackupSetsFromDevices() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.textDeviceSelected_TextChanged(Object sender, EventArgs e) at System.Windows.Forms.Control.OnTextChanged(EventArgs e) at System.Windows.Forms.TextBoxBase.OnTextChanged(EventArgs e) at System.Windows.Forms.Control.set_Text(String value) at System.Windows.Forms.TextBoxBase.set_Text(String value) at System.Windows.Forms.TextBox.set_Text(String value) at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Can anyone help? In the guide (link) noise mentions that when installing, in the beginning, SQL Express, not to use the default account : "You need to specify what account will run the SQL Server. If you leave it at it's default then you may encounter some problems when importing the EVE Online database dump. You can create a whole new user account that will only run SQL Server services if you wish but for simplicity, I will just use my standard login." I am not sure if I did that when i installed it a few years back and not sure how i can create another account or how to use the command line if that is required. I would have posted a comment on noises's i.e. the guides webpage, but he is moved to SQLServer 2012 so not sure if he would even see it. Thanks in advance if anyone can help me out with this [ trying to avoid installing another SQL engine, i.e. starting from scratch, not even sure if its ok to have two engines installed at the same time i.e SQL server 2008 express and MySql for example - some hard disk space issues as well but i could fit in mySQL if i had to, i guess]
Cilegon Volicorp 0	Posted - 2014.08.07 15:43:00 - [2] - Quote the new SDE is SQL 2012 based, so restoring on SQL 2008 likely won't work
Pelorios Pelorios Industries 0	Posted - 2014.08.07 16:02:00 - [3] - Quote i guess you are right, even tried command line from [url]http://oldforums.eveonline.com/?a=topic&threadID=1453254[/url] that didnt work either....hmm what to do....
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 3640	Posted - 2014.08.07 16:31:00 - [4] - Quote All depends what you want to do with it. Mysql and sql server exist quite happily sqlite for the occasional lookup is also an option, and a lightweight one at that. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter
Pelorios Pelorios Industries 0	Posted - 2014.08.07 17:35:00 - [5] - Quote Steve Ronuken wrote: All depends what you want to do with it. Mysql and sql server exist quite happily sqlite for the occasional lookup is also an option, and a lightweight one at that. The impulse was to figure out the best combo of attribute implants for jump clones so as to minimize the cost of getting podded in nullsec. Fitting jump clones with lower level implants, [if you use the same level, there is no point to have a jump clone for that] you can minimize the loss of training time. But then you need just 2 attribute implants on a clone (as opposed to 5) corresponding to the skill that you are training, since you are only using him for a day or so. Now the problem is what are the best/ most efficient combinations of implants. This of course depends on what you are training, but i suspect that you don't need all C(5,2)= 10 combinations, i.e. 10 jump clones which is possible of course but would take a long time to train. So the first step would be to see all skills required attributes i.e. willpower & intelligence to see what the combinations used are. One way is to write them into a spreadsheet by looking at each skill info from the inside the game for all skills, the long way, or....get a dump of all skills with their associated attributes which is what i want to do. Where it will go from there i am not sure, there sure is plenty of sources here and off-site about using the SDD and API. I mostly use XL although i have the express versions of visual studio and SQL 2008 which i have used for other stuff. So far though i am quite happy in XL for EVE, would be nice if i could dump from the static database into it (which is what i am trying to do) but working on an app might be something i'll want to do at some point. That is another topic i.e. whether to stay with Visual studio or work in another language (currently c#) or environment, there seems to be plenty of choice. Back to now...i have downloaded the 2012 express version of SQL and it also seems its possible to upgrade from 2008 sql express, so it wouldnt use to much hd space hopefully but i'll look at sql-lite too, if its usable form XL its probably the most flexible option right now thank you
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 3640	Posted - 2014.08.07 17:50:00 - [6] - Quote sqlite is usable from excel, as long as you install an odbc driver for it. Has the advantage it doesn't act as a server, only opening it when you need it. Not so good for multiple things accessing it, absolutely fine for one person. If /all/ you want is some of the tables from the database in excel format: https://www.fuzzwork.co.uk/dump/crius-1.6-100370/ Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter
Pelorios Pelorios Industries 0	Posted - 2014.08.07 18:08:00 - [7] - Quote It looks like Sqlite then :) Thank you! As for the tables i searched for skills, downloaded IndustryActivitySkills.xls ...its just numbers?! I have to read more on this I think Its funny though, such a simple list of skills with associated attributes and you have to download a database application and use a spreadsheet to get the data.... Still, knowledge is powa :) Ty :)
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 3640	Posted - 2014.08.07 22:57:00 - [8] - Quote Well, if you use the database, you can do all the work in it. you just need something to output it into. My preference is a web page industryActivitySkills is: typeid of the blueprint, activity id,typeid of the skill, level of the skill you can look up the name of the blueprint, and of the skill, in invTypes, with a vlookup. The activity id is in ramActivities. It's to keep the size of everything down. Also, looking up a number is faster than looking up a string. (=1234 is faster than ="I'm a potato") Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter
Pelorios Pelorios Industries 0	Posted - 2014.08.07 23:29:00 - [9] - Quote Steve Ronuken wrote: you can look up the name of the blueprint, and of the skill, in invTypes, with a vlookup. The activity id is in ramActivities. I knew there had to be names in there somewhere!! you just saved me a lot of time :) program 'where are the names' foreach table foreach line in the table if there is a "=" if the next char after the '=' is not in [0,9] print "i found one!' print tabelname, and the 20 chars around the '=' quicky before we lose it!

Pages: [1] :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.