We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Conversion from Access to SQL Server - Assistance

Medium Priority
212 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!
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
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.
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Eileen MurphyIndependent Application Developer

Author

Commented:
I knew I could count on the Experts! Thank you so much! Best, Eileen
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.