Convert website from Access to SQL Server

$250-750 USD

Closed

Posted

over 8 years ago

$250-750 USD

Paid on delivery

I have developed a website for a company in the UK that uses ASP.Net (Visual Basic) and an Access database. The company has grown considerably since then and the website is now having severe slowdown issues. They now need to reset IIS at least once a day. Once reset the site runs ok but eventually it needs resetting again. I have tried optimizing the code as best as I can but now need a permanent solution as the company will only get bigger and take on more staff. I think the solution is to convert to SQL Server but I only have limited experience using it so I need someone to do the conversion and bring me up to speed on developing with it into the future. Although the customer and the website is in the UK, I live in Thailand. It may be possible for this work to be done remotely but another possibility is that the successful candidate should come and work on the conversion here with me (if that were the case I could provide free accommodation). The application is in the field of construction with many detailed steel calculations as well as more general project management functions. Finally, I am unsure as to the budget on this so have left the default selection of 'Very small project' and will see what response I get. This could be a very interesting project for someone and if it goes well there is a lot of further development work in the pipeline that could also be delegated.

IIS

Microsoft Access

Microsoft SQL Server

Project ID: 9083419

About the project

43 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

43 freelancers are bidding on average $545 USD for this job

@sumon355

Hello, I am very much interested to do this work as i have strong knowledge in all the skills required for this project, that means asp.net, ms access, VB and ms sql server. I think i am the best choice for this project. Looking forward to have a positive response from you. Thanks

$250 USD in 7 days

5.0

(288 reviews)

8.1

@fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$526 USD in 10 days

4.8

(83 reviews)

7.3

@amusto

PLease let me have a look at your source code, maybe we can convert to SQL Server with very few changes in the source code to fix the queries. I need to see how much work is needed to place a fair offer for this project.

$736 USD in 10 days

4.8

(11 reviews)

6.6

@ArmiaWassefFayez

i am a senior software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

$400 USD in 10 days

4.7

(54 reviews)

6.4

@fuentro

A proposal has not yet been provided

$555 USD in 10 days

4.7

(27 reviews)

5.9

@hwanghendra

Hi Sir/Madam. Please send details. Thanks. Our slogan: ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

$555 USD in 10 days

4.8

(72 reviews)

5.2

@damianhill40

Hello, I have read your project description and understand that you would like to upsize your access backend to SQL Server. I would be happy to assist you to achieve this remotely. Please take a moment to review my profile, experience and feedback as I have worked on a number of SQL server project successfully. Should you wish to discuss your project in more detail with me please do drop me a message in the chat window. Regards Damian

$500 USD in 5 days

5.0

(7 reviews)

5.1

@Vlzinch

Hello! I work with excel and access for last 5 years and have created hundreds of different database ( from simple to complicated solutions that use VBA MSQL). I do have experience in Visual Basic as well. I will be able to convert existing database into SQL Server and give it required speed and functionality. I have diploma in statistics so I will be easy to understand different calculations and formulas. THe conversion can be done remotely. Even my rating at this site not very high, i really know what i am doing and my reviews can confirm that. If You need somebody who can manage really difficult thing, I am right person, i have good background in SQL and VBA, and all my DB work with 100% accuracy and performance. WIll be happy to discuss the details. Hope for Your respond, Regards, Vlad. Approach to the Job: I will create script, that will be able to connect Your server using ODBC, then filter results in 3-5 different ways to create different reports. When User will press "Update" button, my prog will connect to server and update data/charts/queries/povots. If You need somebody who can manage really difficult thing, I am right person, I am not indian who use recorded or stolen scripts, i have good background in VBA, and all my scripts work with 100%

$526 USD in 10 days

5.0

(2 reviews)

3.7

@dekinghtg

Hi, i have read your problem description and have some commentaries and questions. I agree that the DBMS maybe causing your problem. MS Access is not designed for used by many concurrent users. and the asp.net application tweak and redevelop is a must if you want to switch to MS SQL Server. Questions : 1. How many users using the application? and how many possibility concurrent users using the application? 2. Is it the application now based on ASP.NET MVC? 3. What is the current .Net Framework do you used? REgards

$750 USD in 30 days

5.0

(7 reviews)

3.9

@SkyTechnovation

Hello There, This is Akash Fasara from Sky Technovation (IT Development & Cyber Security Company). From last 5 years we are working on Software & Website development. We have developed too many Software & websites in .NET. Also we have developed our own ERP and Software Products like Super Store Management System, Inventory Management System, Guest House and many more. You can visit our profile for know more about us. It will honorable for us if you will hire Sky Technovation. Regard, Akash Fasara

$526 USD in 10 days

5.0

(6 reviews)

3.4

@EzzoMCT

Hi, i have over 20 years of IT experience a degree in computer science and information systems. and previous experience dealing with converting desktop / web apps from Access to SQL i can walk you through the process and also provide tips for future development. i can work remotely from here in Cairo, Egypt or travel to work on premises with you providing that you will provide flight & Accommodation

$1,666 USD in 5 days

5.0

(4 reviews)

3.5

@suraarumugamsl

Hi I am having 10+ years of experience in .Net, MVC, Web services, Entity Framework and SQL server. I am also having 3 members of team in relevant experience. Please let me know in case you need more details. We can start the work ASAP. Please let me know more details about the project. Thanks!

$388 USD in 7 days

5.0

(1 review)

1.8

@othanorthington

I am Microsoft Solution Provider with many years of experience with MS Access, VBA, VB.NET, SQL and database design and implementation. I will help you with the specifications, detailed design and implementation of your project. I just recently completed a local MS Access project. The project had 6 stations (MS Access front-ends) and a SQL Server back-end with DSN-less connections to the Access front-end. I have also completed ASP.NET projects that use SQL Server for data storage and retrieval. Contact me and we can begin to discuss the details of your project.

$555 USD in 10 days

4.9

(2 reviews)

1.4

@pnjadhav

A proposal has not yet been provided

$833 USD in 15 days

5.0

(1 review)

0.6

@dragomirristic

Dear friend, I already have an idea! I can host database on MSSQL on my server and we can try it over night. I need access database and I can convert it and populate MSSQL and we can do it tomorow night or during weekend. Just on few minutes. Be sure if everything is ok and then work further. I have been in this industry for more than 10 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects. I`m ready to work for you ASAP. We have small team here - a family. My spouse and me, so we can be available 20 hours a day. We have great infrastructure, 100/4 internet, MS Win 2012 server, Debian server in Kansas USA, best possible computers, I`m PC professional - so all hardware is in great condition, we can talk if you would like us to use Skype or VoIP phones, we can have USA phone numbers if needed. My spouse name is Tatjana and my name is Dragomir. Both IT professionals. Our main job here is maintenance of IT infrastructure in "General Hospital Vrsac". You can call us on US phone number (1) 213-262-2885 Thank you for reviewing my proposal.

$250 USD in 10 days

0.0

(0 reviews)

0.0

@softtechsurat

Hello sir/madam, WE CAN START IMMEDIATELY we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better... Regards, Softtechsurat

$555 USD in 20 days

0.0

(0 reviews)

0.0

@charlestown

I am a software developer in the Philadelphia, PA suburbs with over 20 years of experience. How complex is the Access database?

$716 USD in 10 days

0.0

(0 reviews)

0.0

@marossi1971

Full migration , testing and implementationn vb.net development. Microsoft SQL Server 2012 certificate

$255 USD in 3 days

0.0

(0 reviews)

0.0

@voronkov

Hello! Please, check my portfolio, I think I can help you. You have Access database, good news is the Access database objects (tables, indexes and data) can be exported in MS SQL server without problem, slightly worse is the case with SQL queries in ASP (in your VB code), all of them will need to be checked, Access SQL and SQL for MS SQL are slightly different, and if you have programm objects in Access database (for example queries or some code), they are to be moved or in SQL server or VB side. I still have doubts about IIS why it requires a reboot, it seems that there are processes that do not free memory or which is not closed session, possibly something else. You may find that porting to another platform will not work.

$1,111 USD in 30 days

0.0

(1 review)

0.0

@kiranmajeedha

Currently working on these kind of conversion latest conversion is from fox pro to sql server and the conversion can be done in perfect manner and will be deployed with in the time span.

$555 USD in 10 days