Pervasive sql questions
Posted: Wed Apr 06, 2016 9:03 pm
So I have yet to do this, mainly cause I keep forgetting. But I have couple of questions for those that run this setup.
First I take it once this is setup you can't do direct edits to the dats. Do I have to use an update file method instead? Or can nightmare actually still edit it.
Also when it comes to the live data on the board while it's running can you edit while the board still live? So if I wanted to update a item or added a line to a textblock in the sql data, will the board pick it up or do I need to wait for a restart?
Also how does it handle power losses? I run my server in a vm, and sometime when power drops I loose the vm, and I have found sql DB's don't like that very much.
So those two last questions kinda the same with how active is the game with that DB while it running.
First I take it once this is setup you can't do direct edits to the dats. Do I have to use an update file method instead? Or can nightmare actually still edit it.
Also when it comes to the live data on the board while it's running can you edit while the board still live? So if I wanted to update a item or added a line to a textblock in the sql data, will the board pick it up or do I need to wait for a restart?
Also how does it handle power losses? I run my server in a vm, and sometime when power drops I loose the vm, and I have found sql DB's don't like that very much.
So those two last questions kinda the same with how active is the game with that DB while it running.