| Author |
 Topic Search  Topic Options
|
mrg1 
Newbie
Joined: 12 April 2006
Location: Romania
Status: Offline
Points: 15
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrading from 7.x (access) to 8 (MSSQL)
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?
|
 |
iamzaga
Groupie
Joined: 03 March 2005
Location: Turkey
Status: Offline
Points: 43
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2007 at 3:24am |
|
i think this is very helpfull topic if somebody helps.
|
|
mrg1
Newbie
Joined: 12 April 2006
Location: Romania
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
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...
|
|
iamzaga
Groupie
Joined: 03 March 2005
Location: Turkey
Status: Offline
Points: 43
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
mrg1
Newbie
Joined: 12 April 2006
Location: Romania
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
mrg1
Newbie
Joined: 12 April 2006
Location: Romania
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
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...
Edited by mrg1 - 19 February 2007 at 3:45pm
|
|
