SQLServer Access

i'm thinking of changing from Cmud to MUSH, however i have an extensive amount of scripts that i would need to recode into LUA, however luckily for me (mabee) i have most of my actual data that i would like to port across stored in a SQLServer (express 2010 if your curious which version) and i am wondering how or even if it's possible to access this through LUA? and if not, which language would probably be my best bet?

Are you willing to convert to sqlite?

There are quite a few posts about accessing databases from Lua, in particular:

http://www.gammon.com.au/db

and

http://www.gammon.com.au/sql

You could convert to SQLite3, as Fiendish suggested. That might be the smoothest to use in scripts. Or you could use COM or ODBC access to get at your existing database, perhaps.

I am pretty sure you could export from SQLServer into a pure SQL file (export facility) and then, perhaps with a bit of munging of the text in advance, import that into SQLite3.

sorry, i've never used SQLlite,

am i capable of running it as a server with a DNS to it which others can connect to? as that's my ultimate goal is to create a plugin i can then distribute to members of my MUD which will grb the information out of this database, with people being able to always access the latest copy of the data.

So when i make an update, the location of a room in an area for example, or renaming a piece of equipment, it will automatically update everyone accessing the database. rather then having to redistribute and everyone havning different versions.

Ah no, SQLite is intended for single-user operation, at which it is very good.

For your purposes you probably need to stick to your SQL server and access it via ODBC.

One post about that is here:

http://www.gammon.com.au/forum/?id=6324