Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Upgrade from 9.53 Access to SQL Server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrade from 9.53 Access to SQL Server
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
jwmagno View Drop Down
Groupie
Groupie


Joined: 11 October 2008
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jwmagno Quote  Post ReplyReply Direct Link To This Post Posted: 31 October 2008 at 6:25pm
I did the upsize from the Access database to SQL 2005 using the Access 2003 upsizing wizard. Are there any guidelines for doing this? All the tables appear to have data in them.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 31 October 2008 at 6:37pm
If you could provide a link to your forums it might help
Having read your posts I assume you did install SQL forum software?
Visit 123 Simples Web Design
Back to Top
jwmagno View Drop Down
Groupie
Groupie


Joined: 11 October 2008
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jwmagno Quote  Post ReplyReply Direct Link To This Post Posted: 01 November 2008 at 12:31pm

No, I asked that in the beginning and was not told to install different software!

Back to Top
jwmagno View Drop Down
Groupie
Groupie


Joined: 11 October 2008
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jwmagno Quote  Post ReplyReply Direct Link To This Post Posted: 01 November 2008 at 1:04pm
OK, I downloaded and unzipped the SQL version of 9.53.
Updated database_connection.asp to match my SQL database settings
Uploaded to my webserver via FTP.
Same results.
 
Bruce can you help? It's running here: http://66.165.136.37/forum/default.asp
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2008 at 7:49am
Sorry without digging into your server and installation I wouldn't know.

If you have paid for support then try contacting support through your Client Area account with your website, forum, and SQL Server login details for a technician to be able to have a look for you.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jwmagno View Drop Down
Groupie
Groupie


Joined: 11 October 2008
Status: Offline
Points: 33 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jwmagno Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2008 at 6:29pm
I was able to get it running. Here is what I did:
 
1. Deleted all the forum tables on my hosted SQL server
2. Upsized my database to my local SQL Express 2005 instance
3. Imported the tables into my main database on my hosting account. (i had to check the option to enable identity creation when importing data)
 
Note restoring the entire database wasn't an option for me since I have other tables that I don't want overwritten.
 
Anyway it is now running. Thanks for the assistance.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2008 at 6:45pm
Well done and thankyou too for posting how you actually did it. Most peeps just say "I've sorted it" and leave others wondering how Confused

Great news its up and running though Thumbs Up
Visit 123 Simples Web Design
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.