My reseller web host (DIY) migrated a few weeks ago to a new data center.
Unfortunately, my MS SQL databases were not migrating properly. (as well as
other things). I have multiple sites that are not functional due to
problems with their migration.
When I looked at some of the databases, the table structure had been
migrated, but not the data and apparently something else.
Some of the databases of this error when trying to access it:
--- error ---
Error for database: DATABASENAME
Microsoft OLE DB Provider for SQL Server error \'80040e37\'
Invalid object name \'TABLENAME\'.
--- end error---
Some of the databases I can actually access but get:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'TABLENAME', table
'DATABASENAME.dbo.TABLENAME'; column does not allow nulls. INSERT fails.
Everything in all databases worked perfectly before the migration.
They tell me that they have done what they can. They tell me that they are
at the mercy of Psoft who assisted with the migration.
Does anyone know of anything that can my host that can help them figure out