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

進行中 投稿 6年前 着払い
進行中 着払い

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.

マイクロソフトアクセス マイクロソフトSQLサーバー

プロジェクトID: #14555090

プロジェクトについて

29個の提案 リモートプロジェクト アクティブ 6年前

29人のフリーランサーが、平均€172 で、この仕事に入札しています。

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 もっと

€155 EUR 3日以内
(259件のレビュー)
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 もっと

€180 EUR 3日以内
(14件のレビュー)
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 もっと

€111 EUR 3日以内
(49件のレビュー)
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 10日以内
(6件のレビュー)
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 もっと

€250 EUR 30日以内
(22件のレビュー)
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 4日以内
(14件のレビュー)
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 もっと

€180 EUR 2日以内
(レビュー1件)
3.6
sheikDev

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

€111 EUR 3日以内
(8件のレビュー)
3.5
mahesh2761990

A proposal has not yet been provided

€100 EUR 8日以内
(3件のレビュー)
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 15日以内
(4件のレビュー)
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 もっと

€277 EUR 5日以内
(4件のレビュー)
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 もっと

€160 EUR 3日以内
(2件のレビュー)
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 3日以内
(0件のレビュー)
0.0
farmanshah316

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

€155 EUR 10日以内
(0件のレビュー)
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 もっと

€90 EUR 4日以内
(0件のレビュー)
0.0
macogco

I understand how can be integrated MsAccess and MsSqlServer

€111 EUR 5日以内
(0件のレビュー)
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 9日以内
(レビュー1件)
0.1
satishchdry

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

€100 EUR 4日以内
(0件のレビュー)
0.0
rahullancer2017

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

€166 EUR 5日以内
(0件のレビュー)
0.0
bozinovskimario

A proposal has not yet been provided

€220 EUR 3日以内
(0件のレビュー)
0.0