Terminé

Convert MS Access database to MS SQL database

I have an MS Access database containing approx. 60 tables. I need this table to be converted to MS SQL.

I can provide the freelancer the empty database (all tables will be empty) and I need the following:

1. the new database in MSSQL (tables, indexes, unique constraints; there are no foreign keys defined)

This is preferably a set of create scripts which I will run in a newly created database. (I'm an IT person having some understanding of MSSQL, so I don't need any basic instruction how to run a script etc.)

2. An easy solution to move the data from the MS Access database to the new MS SQL database

It can be any solution what I can run easily without too much manual work.

You can also combine steps 1. and 2. by doing an import of MS Access database into MSSQL, but than I need a solution to hadle the autonumber fields.

Compétences : Administration de Bases de données, Microsoft Access, SQL

en voir plus : converting access sql server database, convert access 2003 application database sql 2000, convert access sql server using bids, convert access database to mysql, access 2016 to sql server, convert access to sql server, convert access query to sql, importing access database into sql server, convert access database to sql online, convert access sql to sql server, microsoft sql server migration assistant for access, convert access sql server 2008, convert access sql server freeware, convert access open source database, time estimate convert access sql, convert access sql vba, convert access sql server 2008 free, access sql server database conversion, access sql server database upgrade, convert access sql server express

Concernant l'employeur :
( 14 commentaires ) Budapest, Hungary

Nº du projet : #18030382

Décerné à:

expertcoder1vw

Hi, I'm an expert Access / MS-SQL developer and can convert to MS-SQL, as well as move the data to the new database. The deliverable will be a new MS-SQL database (or SQL scripts - let me know if you prefer this), wit Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 2 jours
(59 Commentaires)
6.0

38 freelance font une offre moyenne de €152 pour ce travail

sumon355

Hello, As an expert in MSSQL and also having sound knowledge in ms access, i am very much interested to do the migration. Do you need to keep the existing auto number in the MSSQL database also, or new auto number wou Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(190 Commentaires)
7.1
branislavm

Hi! Converting is an easy part, there are even tools for that, but I guess the major concern is to update ID's. Am I right? That can be done by several SQL commands or scripts in MSSQL. Can I see the actual datab Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(231 Commentaires)
7.2
feninsoftech

Hi, This will be achieved by first creating all constraints and indexes and then importing data using SQL Import wizard. Once imported, we can take backup and restore wherever required. I have 10 years experience Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(43 Commentaires)
6.5
mpalgeo

Hi there I have done similar projects in the past and i can provide you a solution. I have a question, the Access will act as an interface to MSSQL ? I will also convert the Queries of the Access into Views to MSSQL Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(46 Commentaires)
6.1
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Convert MS Access database to MS SQL database. I've delivered more than 400 + projects in the last 5 years and this makes me very Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(15 Commentaires)
5.5
marasinghe82

Dear Sir, I'm expert ETL developer on SSIS. I can complte this task within today and get back to you with .bak & SSIS solution with automation for data transfer between MS SQL and MS Access Database. please share th Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(66 Commentaires)
5.7
crypthne

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(31 Commentaires)
4.5
pnjadhav

Please review my profile I am working with skills that you required for this job for 16 years. I am working with MS Access, Excel, MS SQL, VBA, API and .Net for a long time. I can definitely help you with this job, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(6 Commentaires)
4.1
reedsystems

Hello there! I read your project description and I understand your requirement. I can help you to convert MS access database to MySql since that is what I am good at. So be rest assured that I can provide you wit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(16 Commentaires)
4.0
tangramua

Hello! I can help you to convert MS Access database to MS SQL. As for me I'm a professional web developer with 15+ years of experience. My main specialization is Python, LAMP (Linux, Apache, MySQL, PHP) and MEAN Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)
3.8
idragon712

Hello How are you? I have read your description carefully and known what you mean. I have high skill with MSSQL. If you hire me, I will do my best. I hope we can discuss about your project in more detail via chat. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(3 Commentaires)
3.3
dreamfusionadmin

Dear Sir, I am an expert in both MS SQL and MS Access had done similar projects before. I will create a two Scripts which you could run on MS SQL server for creation of tables and second script to populate the data. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)
3.0
Tanmoy236

Completed more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satis Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(4 Commentaires)
2.9
alhassanlatif

Hi, I am a professional Access developer I have done many great projects in Access have a look at my profile I can convert the DB to MSSQL

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(4 Commentaires)
3.1
sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with database management. I have finished many projects like this. I'm confident in your project and I promise to do your project in time. Hope your k Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)
2.2
abfreelancec

Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8.11 years experience in MS SQL Server and 6.2 years experience in SSRS, SSIS (Import / Export). Please let me know m Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
2.3
jinijose

Having 20 years of experience in Software Industry, expertise in design and Implementation of Web based Applications using C#.Net, VB.Net, ASP.Net, SQL SERVER, ASP, CRYSTAL REPORTS, MS ACCESS, HTML, PHP, VBSCRIPT, JAVA Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 8 jours
(1 Évaluation)
1.6
FairDeveloperUk

I'm currently working on Access to SQL importing and have recently created my own utility which is like SSMS but for Access which I can pass on to you for your ongoing importing, I can do this work for you and will com Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)
1.8
gracefulwork

Hi I am mysql conversion expert. lets start. I can convert your ms-access database to mysql database. Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 6 jours
(2 Commentaires)
1.5
marcelorfurtado

Hello, I have more than 15 years of experience with software development and I am SQL Server DBA since SQL Server 2000. (including Microsoft certification). Which version do you use from Access and SQL Server? I' Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(1 Évaluation)
1.0