Convert MS Access application's DB part from MS Access to MS SQL

In Progress Posted 6 years ago Paid on delivery
In Progress Paid on delivery

I have an application written in MS Access 2003 SP3. The database is another MS Access files and the DB tables are linked to the application as linked tables.

The task is to change the database from MS Access to MS SQL Server 2008 database and make the necessary changes in the application to start using MS SQL tables instead of the MS Access linked tables.

In my application I'm using the following techniques to Access and manipulate data:

- I have a set of queries to get data from tables (I'm not using queries to manipulate data)

- In the code I use [login to view URL] structures to process Records

- In the code I use [login to view URL] statements to manipulate data

- In the code sometimes I use DCount() and DSum() functions, too

The database contains approx. 35 tables (out of which 15 are very similar).

The application contains approx. 20 queries.

The application contains approx. 30 forms, 30 reports and 6 modules

I can accept two solutions:

1. You give me an exact description of how to convert the database and you also give me a description what to do with each and every type of query, command etc.

2. I give you the full application and DB and you do the conversion.

Microsoft Access Microsoft SQL Server

Project ID: #14555090

About the project

29 proposals Remote project Active 6 years ago

29 freelancers are bidding on average €172 for this job

branislavm

Instructions how to upsize the database Relevant Skills and Experience MS Access/SQL developer for 24 years Proposed Milestones €155 EUR - Completed project Hi from Serbia! Just one question - do you want to make d More

€155 EUR in 3 days
(259 Reviews)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

€180 EUR in 3 days
(14 Reviews)
5.8
paskal77

Hi, I have received the specification of your project and I am sure to be able to develop it, Please contact me by chat. Thanks Relevant Skills and Experience Do you need to only migrate the ms access database to More

€111 EUR in 3 days
(49 Reviews)
5.5
IMExpertEngineer

Hi, Please send me the full application and code and I'll do everything myself as I'm expert in sql server and I can do this job very well. Thanks

€250 EUR in 10 days
(6 Reviews)
4.6
AliSafder

change the database from MS Access to MS SQL Server 2008 database and make the necessary changes in the application Relevant Skills and Experience 8 years of experience in Databases like Sql Server, Oracle, Microsoft More

€250 EUR in 30 days
(22 Reviews)
4.5
phiona06

I can help with your task. Relevant Skills and Experience I'm senior lecturer on databases with 10+ years experience in differnt DBMS (including MS SQL Server, MS Access). Proposed Milestones €155 EUR - full task

€155 EUR in 4 days
(14 Reviews)
4.0
zekovicm

Hello, I have carefully gone through with your requirement.I am going to do this job all by myself ! Feel free to contact me anytime to discuss further details. I can say that I am really fast, confidential, effici More

€180 EUR in 2 days
(1 Review)
3.6
sheikDev

Hi, What kind of application you are looking to migrate in ms SQL. Please let me know.

€111 EUR in 3 days
(8 Reviews)
3.5
mahesh2761990

A proposal has not yet been provided

€100 EUR in 8 days
(3 Reviews)
3.2
HDDevelopment

Dear sir, good day , i have 10 years experience in sql database , vb.net , c# and asp.net kindly tell me what code do you use vb.net or c# etc. i can do full convert. Best Regards, Hassan

€247 EUR in 15 days
(4 Reviews)
3.0
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

€277 EUR in 5 days
(4 Reviews)
2.3
ske777

Greetings, I am experienced database designer and SQL specialist who can really help you with this project. First I will make research of existing DB in Access afterwards I will convert data and give you new DB in M More

€160 EUR in 3 days
(2 Reviews)
0.2
SalesforcePerson

I can write you a tutorial with screenshots. Do you know creating database from script in MSSQL? Relevant Skills and Experience MS ACESS MSSQL VBA Proposed Milestones €90 EUR - complete tutorial with screenshots

€90 EUR in 3 days
(0 Reviews)
0.0
farmanshah316

N/A Relevant Skills and Experience Sql, .Net, Android, iOS Proposed Milestones €155 EUR - N/A

€155 EUR in 10 days
(0 Reviews)
0.0
khoddam

Convert from access to MSSQL Relevant Skills and Experience C# , Database , MS Access, MS SQL Proposed Milestones €90 EUR - Full conversion How do you want to run the new database? by itself? in the web or a desktop More

€90 EUR in 4 days
(0 Reviews)
0.0
macogco

I understand how can be integrated MsAccess and MsSqlServer

€111 EUR in 5 days
(0 Reviews)
0.0
hippkreddy

we can do this as we have done many projects. Relevant Skills and Experience we have 11+ years of experience in Software and website development. Proposed Milestones €155 EUR - 155

€155 EUR in 9 days
(1 Review)
0.1
satishchdry

I will finish the proposed work and also make the necessary configuration to give best performance.

€100 EUR in 4 days
(0 Reviews)
0.0
rahullancer2017

hi i have good working experience in migration from legacy db to sql thanks

€166 EUR in 5 days
(0 Reviews)
0.0
bozinovskimario

A proposal has not yet been provided

€220 EUR in 3 days
(0 Reviews)
0.0