In Progress

Sort out MS SQL db so aspx website will work

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"

errors.

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.

Many thanks.

Skills: ASP, SQL

See more: sort database sql, sort sql, website procedures, website formats, website errors fix, value website, sql data conversion, microsoft fix website, fix website restore error, data conversion sql, sort function, website studio, microsoft website, uploading website, stored procedures, sql microsoft, sql code, sql c, out, ms sql, mis data, microsoft sql website, microsoft sql server, drawing conversion, db

About the Employer:
( 31 reviews ) London, United Kingdom

Project ID: #538822

Awarded to:

AlosDeveloper

Helo please see PMB

$150 USD in 0 days
(31 Reviews)
6.3

8 freelancers are bidding on average $132 for this job

shmai

have a glance at PM. Regards,

$246 USD in 6 days
(173 Reviews)
6.9
TakeReal

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.

$100 USD in 2 days
(446 Reviews)
6.7
YashpalSingh123

Hello, Expert Computer Engineer, in ASP.net,,C#, Sql2008, Can Start Work on Immediately effect. Thanx

$100 USD in 1 day
(8 Reviews)
4.4
manooppa

I am interested in working on your project. I have 3 year experience in web application. I took part around all the aspects of software engineering Analyses, Design , Database design, Coding in both backend an More

$100 USD in 3 days
(9 Reviews)
3.6
developer84

Hi check Pm Please Thanks

$60 USD in 2 days
(1 Review)
1.3
itconsultant1

Please see PM for more details.

$200 USD in 0 days
(0 Reviews)
0.0
johnscoder

Have worked with SQL server 2008 on ASP sites.

$100 USD in 2 days
(0 Reviews)
0.0