Database Discussion - Migrating from Access to SQL database

Print Page | Close Window

Migrating from Access to SQL database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30203
Printed Date: 28 March 2026 at 9:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Migrating from Access to SQL database

Posted By: Nauti Rogue
Subject: Migrating from Access to SQL database
Date Posted: 04 March 2012 at 6:45pm

I've just built a new Small Business Server 2011 Standard with the intent of migrating my Forum. I had been running the forum on Server 2003 (32-bit) with and Access database without issue. I had hoped to still use the Access database on the new server, but the 64-bit architecture (Server 2008 R2) seems to not play well with ASP and the Access ODBC stuff.

Since I have the SQL Server now, I may as well take advantage of it, but I haven't found any instructions on migration. Can someone point me in the right direction?

Thanks!

Replies:

Posted By: Nauti Rogue
Date Posted: 05 March 2012 at 11:09am

Sorry, a better search turned up several good threads regarding the upsizer. I'll run with those!

Posted By: RCorr
Date Posted: 23 April 2012 at 1:40pm

Nauti,

Have you had any success. Maybe this http://www.bullzip.com/products/a2s/info.php" rel="nofollow - software will help what you are trying to accomplish.

Best of luck