Web Wiz Support and Community Forums : Upsize from Access to SQL Server https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 23:39:46 +0000 Wed, 11 Feb 2004 20:07:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9754 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upsize from Access to SQL Server : Do a search.We have answered such...]]> https://forums.webwiz.net/upsize-from-access-to-sql-server_topic9754_post52386.html#52386 Author: fantasy
Subject: 9754
Posted: 11 February 2004 at 8:07pm

Do a search.
We have answered such kind of question before.

]]> Wed, 11 Feb 2004 20:07:04 +0000 https://forums.webwiz.net/upsize-from-access-to-sql-server_topic9754_post52386.html#52386 <![CDATA[Upsize from Access to SQL Server : Before the flames start, I know...]]> https://forums.webwiz.net/upsize-from-access-to-sql-server_topic9754_post52371.html#52371 Author: xeerex
Subject: 9754
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



Edited by xeerex]]> Wed, 11 Feb 2004 17:14:27 +0000 https://forums.webwiz.net/upsize-from-access-to-sql-server_topic9754_post52371.html#52371