Upgrading from 7.x (access) to 8 (MSSQL)
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22494
Printed Date: 30 March 2026 at 3:03pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrading from 7.x (access) to 8 (MSSQL)
Posted By: mrg1
Subject: Upgrading from 7.x (access) to 8 (MSSQL)
Date Posted: 23 January 2007 at 7:12pm
I've checked briefly this forum mut I couldn't find any help for my issue:
I've started to use WW Forum version 7.91 on Access. On that time the traffic was not a problem so the Jet performed ok.
Now I've reach somewhere at about 3000 user per day and Jet seems to reach its capabilities.
Before answering, please take into consideration the fact that I've no ideea about Ms SQL but with a little help from my frends I hope to solve this situation.
I downloaded latest version of WW Forum for MsSQL, I exported database using DTS tool from MS, modifying resulted database with your upgrading tool, and then nothing...
Somebody told me something about stored procedures, that they're missing.
What should I do?
|
Replies:
Posted By: iamzaga
Date Posted: 25 January 2007 at 3:24am
|
i think this is very helpfull topic if somebody helps.
|
Posted By: mrg1
Date Posted: 25 January 2007 at 8:13am
I've found a way for upgrading... Using upgrading tool for access 7.x to 8, I've made the conversion then with "Upsizing" function in Access I've converted the mdb into MS SQL database. The rezults looks ok bout I didn't have much time for testing...
|
Posted By: iamzaga
Date Posted: 26 January 2007 at 1:43am
|
you mean i can automaticly converse mdb to mssql with ms access 2007? Can tell it in details?
|
Posted By: mrg1
Date Posted: 26 January 2007 at 4:44am
|
Not sure about Access 2007, but 2000 (that's the version I use) has an "Upsize" option in "Tools" >> "Database options" menu. The other option (and more reliable) is to use DTS tool, shipped with MSSQL.
|
Posted By: mrg1
Date Posted: 19 February 2007 at 3:38pm
...follow up: It was a nightmare... Finally, I've done the following: I used upsize tool form access just for moving structure (without data) on remote sever. Then with DTS tool I've inserted the data on server datatabase.
If I try to move structure AND data, I should spent about 3 hours for a mdb file not execeding 12 MB. With DTS all went just smooth and by far faster...
On the other hand, I've used DTS only... That misterious and undocumented error rised up saying that a query is not updateable...
|
|