Web Wiz Forums - Upgrade Access 2002 to SQL 2000 Possible?

Print Page | Close Window

Upgrade Access 2002 to SQL 2000 Possible?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=244
Printed Date: 29 March 2026 at 2:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrade Access 2002 to SQL 2000 Possible?

Posted By: dolby71
Subject: Upgrade Access 2002 to SQL 2000 Possible?
Date Posted: 17 February 2003 at 9:02am

Right now i'm using access db for my forum.
Is it possible to UPGRADE the current DB to a SQL 2000 DB?
Instead of just having to start it all over again....

Replies:

Posted By: michael
Date Posted: 17 February 2003 at 9:21am

yes. it is possible using dts or the upsizing wiz. in access

Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 9:23am

If you use the upsize wizard, select to create the database on a local SQL server, if you select the DSN option, it won't create all the relationships or default values.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dolby71
Date Posted: 17 February 2003 at 10:48am

OK, Thanks.
I asked that since i want to move to a new server, that supports SQL 2000.