SQL database conversion from 2005 to 2000

Completed Posted May 22, 2009 Paid on delivery
Completed Paid on delivery

We built a database for our client in MS SQL 2005, but now it turns out that they actually have a MS SQL 2000 system and cannot upgrade. We are looking for someone who can convert database files from 2005 to 2000 and help ensure that it will run on their older MS SQL 2000 system. There MAY BE modifications required for the accompanying ASP application.

The database + application is about 200MB (compressed) and I can ftp it to a location you specify.

Summary of tasks:

1) Conversion of the database from MS SQL 2005 to MS SQL 2000

2) Changes to tables / etc within the accompanying application (IF necessary)

3) Quick testing of the application by installing it at your end (NECESSARY, but extremely straightforward)

4) Creation of simple screenshot based installation instructions for our clients

A DB expert who took a look at this said that the tables used VARCHAR, which are not supported in 2000 and would need to be converted to something appropriate. ----------------------------------------------- Responding to comments: - There are many tables, I'm sorry, but I don't have an exact number (I don't have MS SQL on my system). I'm guessing somewhere between 30-50. - The DB expert mentioned that varchar(max) is being used in the system and it is equivalent to text or varchar(something else) in 2000. - There are no SQL scripts being used. The DB expert also mentioned that. - The application is made using ASP.NET (I checked the directory folder and there are many files *.aspx and *.[url removed, login to view]) - Regarding stored procedures, it is my understanding from my developers that nothing like that was done. The database was used simply to store information, that's it.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MS SQL 2005 MS SQL 2000

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3900090

About the project

29 proposals Remote project Active May 23, 2009

Awarded to:

hwanghendra

See private message.

$63.75 USD in 3 days
(404 Reviews)
6.8

29 freelancers are bidding on average $65 for this job

gkalish

See private message.

$63.75 USD in 3 days
(244 Reviews)
6.3
vnb400sl

See private message.

$85 USD in 3 days
(113 Reviews)
5.8
expertechie

See private message.

$75.65 USD in 3 days
(85 Reviews)
5.8
jawadh

See private message.

$85 USD in 3 days
(76 Reviews)
5.9
sathyanus

See private message.

$85 USD in 3 days
(82 Reviews)
5.2
nextconsultant

See private message.

$76.5 USD in 3 days
(67 Reviews)
4.8
andreylysachenko

See private message.

$59.5 USD in 3 days
(5 Reviews)
4.7
oraclequest

See private message.

$85 USD in 3 days
(51 Reviews)
4.7
californianative

See private message.

$76.5 USD in 3 days
(35 Reviews)
4.6
izharuislam

See private message.

$85 USD in 3 days
(27 Reviews)
4.5
wesolvevw

See private message.

$59.5 USD in 3 days
(49 Reviews)
4.4
ideaworks09

See private message.

$68 USD in 3 days
(13 Reviews)
4.0
techtrouble

See private message.

$85 USD in 3 days
(10 Reviews)
3.8
ashok7925

See private message.

$34 USD in 3 days
(5 Reviews)
3.6
smartsaqib

See private message.

$85 USD in 3 days
(14 Reviews)
3.5
apldesigns

See private message.

$85 USD in 3 days
(14 Reviews)
3.4
irfanaliQAU

See private message.

$72.25 USD in 3 days
(10 Reviews)
3.7
perfectcoder09vw

See private message.

$34 USD in 3 days
(10 Reviews)
2.5
naganagamani

See private message.

$30.6 USD in 3 days
(12 Reviews)
2.3
jeevaka

See private message.

$76.5 USD in 3 days
(2 Reviews)
1.5