Upsize from Access to SQL Server
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=9754
Printed Date: 07 April 2026 at 11:48pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upsize from Access to SQL Server
Posted By: xeerex
Subject: Upsize from Access to SQL Server
Date Posted: 11 February 2004 at 5:14pm
|
Before the flames start, I know this has been discussed in several threads and NO i am not a WWG newbie. However, I am not that well trained on SQL Server so here is the situation: My newest forum is generating an avg of more than 50 active users and most of the time it is over 100. I know the limitations of Access but I did not forsee this much traffic or I would have started with SQL Server in the first place. I anticipated a lot of posts but not the concurrent users. My problem is that I can download the SQL Server version of the forum and can get that setup once I get my SQL Server database going with my host, and I can run the upsize wizard in Access. How do I connect from the local Access database to the SQL Server database which is on my host's server? Is there a way to import my local copy to my host? Next question: If there is a SQL Server setup page with the forum, has anyone ever considered making an "upgrade" script that would import the information from the existing Access database directly into the SQL Server database? /edited the 3rd paragraph for clarification ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Replies:
Posted By: fantasy
Date Posted: 11 February 2004 at 8:07pm
|
Do a search. ------------- Welcome to my website: PC Pioneer - the latest software news and forum site, Neowin in China! "http://www.pcpchina.com" - http://www.pcpchina.com |
