We've moving an .aspx site to our servers. We have a zip of the site files and a .bak of the db. We've uploaded the site files and restored the db from the .bak.
Initially nothing worked because none of the stored procedures had been copied across during the restore. I scripted all the stored procedures and copied them to the live db.
Then a few functions wouldn't work because during the restore no columns were set to autoincrement, so I rescripted all the tables and rebuilt the tables on the live server. Then did the same again to copy the data across to the live server.
Now we still have an image drawing/showing function where we are getting an
"URI formats are not supported" error
and a number of save to db functions where we are getting
"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"
I believe the code is in order and the problem is in the db. I think these errors are coming from variables being mis-cast, probably the regional settings on the db are incorrect or something so the date is in the correct format but the db is wrongly expecting it in a different format.
We need someone who knows MS SQL to fix this quickly and simply.
Either by simply uploading/restoring the correct, complete db to the live server from the .bak or by knowing where and how to affect the regional settings.
The live server uses a Microsoft SQL Server 2008 database.
You can connect to this database using SQL Server Management Studio 2008. Please ensure you have this before bidding.
8 freelancers are bidding on average $132 for this job
Can I have access to old MS SQL database? I will backup it in my way and restore on new server. Next - I will run your ASPX code and check all database-related errors. I need FTP access and access to MS SQL Server.