Migrating Access Database to SQL Server
page 1 of 6
Published: 14 Sep 2006
Abstract
In this article Byapti demonstrates how to migrate Access database to SQL Server with the help of sample code.
by Amrita Dash
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 64650/ 103

Introduction

Migration is the process of moving some or all database objects from an Access Database (.mdb) to a new or existing SQL Server database or new Access Project (.adp).  A move from Access to SQL Server is generally considered for performance, security and stability.  With the increased volume of databases and with a large number of database users, one may need to convert the Access database to a client-server environment of SQL Server.  Upsizing the access database to SQL server will solve this problem and provide a better application for a large number of users with less network traffic.


View Entire Article

User Comments

Title: Mr   
Name: Ajayi Gbolahan
Date: 10/17/2011 12:54:49 PM
Comment:
This is exactly the challenge i am confronted with at present i hope this will solve my promlem
Title: Academic Professor   
Name: Dr. Fekry Fouad
Date: 8/1/2010 10:42:12 AM
Comment:
Hi

Finally I got what I was looking for , it is an excellent step to migrate from ACCESS database into SQL and VB.NET.

I am Egyptian professor , currently I am on Saudi Arabia for consultancy (maily migration) , I would like to know more - if possible - about the methodology . in case you like the idea , please advise how we can cooperate , a lot of business and the backlog of access is so much , all of them are very much willing to have a saved migration.

Please send this answer to info@ittg.org

Regards

Dr. Fekry Fouad
00966560037271
Title: Academic Professor   
Name: Dr. Fekry Fouad
Date: 8/1/2010 10:40:13 AM
Comment:
Hi

Finally I got what I was looking for , it is an excellent step to migrate from ACCESS database into SQL and VB.NET.

I am Egyptian professor , currently I am on Saudi Arabia for consultancy (maily migration) , I would like to know more - if possible - about the methodology . in case you like the idea , please advise how we can cooperate , a lot of business and the backlog of access is so much , all of them are very much willing to have a saved migration.

Regards

Dr. Fekry Fouad
00966560037271
Title: SQL Svr DBA   
Name: KLM
Date: 4/9/2010 9:10:03 AM
Comment:
Hello Amrita.
I am currently involved in Migrating our Access2007 based application back-end (database) to SQL Server2005.
That said, I am using the client – server application approach that requires me to modify the ADO connect string.
Thus my question to you is:
How do I or where do I go to change the Connect string in the generated __.adp project file?

Thank you.

KK.

Please send this answer to kkmore@yahoo.com
Title: Migration   
Name: Sudhir Kumar
Date: 1/29/2010 6:12:37 AM
Comment:
i neeed urgently a code to transfer access table to sql server 2000
please help out
Title: Mr   
Name: Keith
Date: 12/17/2009 8:51:46 AM
Comment:
This type of article helps new computer profeshnals.
Title: migration   
Name: ashish
Date: 7/13/2009 9:37:39 AM
Comment:
i neeed urgently a code to transfer access table to sql table
please help out
Title: stored procedures   
Name: raimund popp
Date: 4/12/2007 10:12:25 AM
Comment:
did you also find a way how to get the sql-property of a stored procedure like querydefs(xx).sql

regards
raimund
Title: Covert excel file data into a MSSQL server databases   
Name: indu
Date: 1/30/2007 9:50:26 PM
Comment:
I want to upload a Excel file datas into MSSQL serve databae
Title: Great Article   
Name: Mike
Date: 1/22/2007 3:41:25 PM
Comment:
That has to be one of the best examples I have seen, saving me hours of writing stored procedures. Great example, especially the DAO / ADO comparison.
The only suggestion is to remove the space from the line:
rs("TextFieldName ") = NewValue
it should read rs("TextFieldName") = NewValue as that extra space cause Access to Error on Item not in collection (Error 3265). Thanks for saving me many hours.
Title: Problems with relation database   
Name: Ananda
Date: 12/5/2006 2:44:27 AM
Comment:
Hi!

Its excellent article.
But problem is relational database.
If you have primary id of one table as foreign key to another table then exporting database by this way will not slove that problem.
Relation will not work as the new id will be different that what you have in your your foreign table.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 4/16/2014 3:14:28 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search