I needed to move DNN to a new server and the way I moved the database was to export all data to a blank db on the new server. Then I generated SP scripts and ran that script on the new server. During the export, I got a few errors like "could not enter NULL into dbo.webserver". I believe the fields were serverID and Enabled.
I enabled NULL input on those fields just to move past the error but then I got multiple entries for the new server with NULL in serverID and Enabled. After that, I started to receive errors saying that multiple NULL records could not be entered. I had numerous entries with those two fields NULL.
I deleted all but one of the entries, changed the ID from NULL to 3 (1 and 2 are the only other entries from the old server) and changed Enabled from NULL to True. then I removed the "Allow NULL" setting on those fields.
Can anybody confirm that this was the right move? It seems to have solved the problem but if there is a better solution, I'd love to know what exactly this table is for. It appears to be only in newer versions so I can't really find a reference point from older installs.
Should I be okay going forward? Do I need to do anything to the entries referencing the old server or can they remain? Could I have avoided this by moving the db using another method? Etc.
Many thanks to anybody who can shed some light.