SQL Server 2008

[So_1337]

.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.

[nosfentora]

This might help.

If not, I believe you can run a new query on the existing connection, copy and paste the text from the .sql file and run the query.

The last I've used was SQL Server 2005, I'm not sure what they've changed in 2008.

you could also try renaming the .sql file to a .txt file and see if that'll import. - you might have to change some of the syntax tho.

[blackdragonsdg]

What was happening was when I went to import the sql file it would start the process then start giving row and column errors and then just end the import operation. That is most likely because I did not have the program configured correctly or just made a simple mistake out of inexperience.

The sql file I was using was a database export of my minilogin which I know works or atleast it does on mysql. I'll probably put it in text format and try again later when I have more time to tinker with it.

[nosfentora]

You might want to try selecting all the data in your database (via Navicat or something similar), copying and pasting into excel. Then save to a .CSV file.

That should import easier into SQL Server.

[drakelord]

Not sure if the queries that world/zone server use are compatible with SQL Server either. You might end up having to make changes and recompile the code. And it would be quite a few changes.

[nosfentora]

yea the queries are a little different, which is why exporting via navicat (to a csv format) and then importing with 2008 choosing a csv format should work.

[EvoZak]

I think drake's point is that the emulator doesn't really have a data layer per se. Rather, a bunch of embedded sql queries throughout the code.

Not that there's anything wrong with that. Just not easy to switch back ends.