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):
40024/
77
|
|
|
|
| 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.
|
|
|
|
User Comments
Title:
Mr
Name:
Ajayi Gbolahan
Date:
2011-10-17 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:
2010-08-01 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:
2010-08-01 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:
2010-04-09 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:
2010-01-29 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:
2009-12-17 8:51:46 AM
Comment:
This type of article helps new computer profeshnals.
|
Title:
migration
Name:
ashish
Date:
2009-07-13 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:
2007-04-12 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:
2007-01-30 9:50:26 PM
Comment:
I want to upload a Excel file datas into MSSQL serve databae
|
Title:
Great Article
Name:
Mike
Date:
2007-01-22 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:
2006-12-05 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.
|
|
|
|
|
|
