Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Conversion from Access to SQL Server - Assistance

Posted on 2011-04-26
4
Medium Priority
?
190 Views
Last Modified: 2012-05-11
Hey Experts! I am going to be migrating a client's back-end Access DB to SQL Server and know that code changes will be required, queries may be impacted, stored procedures and pass through queries may be recommended -- I wondered if there were a site to help me make sure I cover all my bases and to help me expedite the process. I have upsized the data a couple times and it all went in fine -- data is normalized -- But I've done this is the past and neglected to take notes on all that I had to do.

I appreciate any direction you may have for me.

Thanks a lot!
0
Comment
Question by:Eileen Murphy
4 Comments
 
LVL 2

Accepted Solution

by:
Ghasano earned 1000 total points
ID: 35471721
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35473311
Import fulll Access file to SQL Server.

Do changes in code appropriate with Query (IIF to Case)
Connection (Connectionstring)

You can create SP, trigger and functions.
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 1000 total points
ID: 35473766
what is your access version and sql server version edition?

check:

How to convert an Access database to SQL Server
http://support.microsoft.com/kb/237980

Microsoft Access 97 Upsizing Tools
http://www.microsoft.com/downloads/en/details.aspx?familyid=f5c7a907-7c5f-46cb-9157-a1ec4e96083d&displaylang=en

How to Migrate from Access to SQL Server 2000
http://technet.microsoft.com/en-us/library/cc917602.aspx

--
sql 2005 and 2008Migration for Microsoft Access
http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

use
SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/DOWNLOADS/en/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b&displaylang=en


0
 

Author Closing Comment

by:Eileen Murphy
ID: 35475190
I knew I could count on the Experts! Thank you so much! Best, Eileen
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question