Project Detail

Sort out MS SQL db so aspx website will work  

Sort out MS SQL db so aspx website will work is project number 538822
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: sadam

Budget: $30-250

Created: 10/29/2009 at 6:08 EDT

Bid Count: 8

Average Bid:
$ 132

10/30/2009 at 6:08 EDT

Project Creator: entropyid
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (6 reviews)

Bid On This Project
 

Description

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.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

2 days

10-29-2009 07:40 EDT

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.

help

 

246

6 days

10-29-2009 08:16 EDT

have a glance at PM. Regards,

help

 

150

0 days

10-29-2009 08:06 EDT

Helo please see PMB

help

 

100

1 day

10-29-2009 06:26 EDT

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

help

 

60

2 days

10-29-2009 08:14 EDT

Hi check Pm Please Thanks

help

 

100

3 days

10-29-2009 08:44 EDT

(No Feedback Yet)

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 and frontend. Please take a look at some of my previous work: http://www.recruitmentfactory.com http://www.securestudents.com http://www.ewetpaint.com I have read you requirements and submitted a bid of $100 for your project. And will finish in 2- 3 days. If I can provide you with any further information on my background and qualifications, please let me know. I am happy to discuss further. You can reach me online between 4 am - 7pm your time (GMT). I also have a few clarifying questions on the project: Thank you, Manoop Paul Kurian

help

 

200

0 days

10-29-2009 09:15 EDT

(No Feedback Yet)

Please see PM for more details.

help

 

100

2 days

10-29-2009 09:24 EDT

(No Feedback Yet)

Have worked with SQL server 2008 on ASP sites.

help


    Bid on this Project