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.
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
38 freelance font une offre moyenne de €152 pour ce travail
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Hi I am mysql conversion expert. lets start. I can convert your ms-access database to mysql database. Thank you.
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