Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2009, 09:46 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default SQL Server 2008

I was wondering if anyone has tried using SQL Server 2008 in place of MySQL for their database? If so, are there any pitfalls to be aware of? I would think compatibility might be an issue as it was with MySQL versions.

I was thinking about trying it but I thought I would ask here and see if anyone had any advice for or against the idea.
Reply With Quote
  #2  
Old 04-16-2009, 10:06 PM
image
Demi-God
 
Join Date: Jan 2002
Posts: 1,290
Default

Last I checked it was made for mysql, are you talking about Microsoft SQL? Then I really don't think thats going to work
__________________
www.eq2emu.com
EQ2Emu Developer
Former EQEMu Developer / GuildWars / Zek Seasons Servers
Member of the "I hate devn00b" club.
Reply With Quote
  #3  
Old 04-16-2009, 10:52 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

Yes, I was referring to Microsoft SQL Server 2008.
Reply With Quote
  #4  
Old 04-16-2009, 11:35 PM
Andrew80k
Dragon
 
Join Date: Feb 2007
Posts: 659
Default

You could probably get it to work, but it would take a bit of work. You'd have to look at the database stuff to see. It's not really abstracted out completely though. You could likely use any database you wanted but you'd pretty much have to do the work.
Reply With Quote
  #5  
Old 04-17-2009, 06:51 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

So after about four hours of tinkering around with SQL Server 2008 I am not having much luck even getting the database to import/source in. For some reason the program doesn't want to use .sql files it wants .txt or .csv and I have never heard of .csv until today. I think I am way outta my league on this idea.

I think SQL Server 2008 would be much more useful in hands of an experienced database administrator. Seems to have lots and lots of tools and a whole bunch of other gadgets I don't know what to do with.
Reply With Quote
  #6  
Old 04-17-2009, 08:54 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

.csv files are simply comma separated values. It's a popular export method for a lot of Windows-based programs like Excel, Access, and MySQL.

I've gone through the work before of exporting entire tables from MySQL into .csv, opening them in Excel, adding a blank column before all the information, and then using it to write queries. From there, I just copy the whole deal into a text file, save it as a .sql file, and source it in. So for most tables that are just simple integers or text, that would work for you, though it'd take some work. I have no idea how you'd handle anything like the player profile or blobs.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:28 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3