Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL Server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server

 Post Reply Post Reply
Author
Cybreed View Drop Down
Newbie
Newbie
Avatar

Joined: 03 November 2002
Location: Malaysia
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Cybreed Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server
    Posted: 20 August 2004 at 10:30pm
Hi

Im currently running Access version of WWF. And because of constant slowdowns especially in the evening I checked the database it has reached 10MB. And constantly there are simultanious 10-20 connections in the evening. I would like to migrate to SQL. My question are

  • How do I go about moving the information in access database to sql database?
  • How do I set it up with my hosts?
  • Is there a migrating script or something like that ?
And
  • YES I have searched the forums and didnt find a suitable scenario to work upon.
  • YES my host supports mySQL and SQL Server.
My current forum is generated within 0.2 seconds with 6 ppl in it. But when night comes I get all this complaints filling up my mailbox. Im feeling abit frustrated. Please assist. Thanks a mil

Cyb

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: 21 August 2004 at 5:18am
Moving to MS SQL Server is not a simple process.

You will have to contact your hosts and findout from them how to setup an MS SQL Server Database as each host has a different system.

Once the database is setup you need to download and install the MS SQL Server version and run the MS SQL Server Setup file to create the database and all the stored procedures on the MS SQL Server.

Then you need to find someway of exporting the data into the MS SQL Server database.

You could try using the Upsize tool in Access to do this, but it may require that you delete all the table on the SQL Server first (not the stored procedures).
Back to Top
 Post Reply Post Reply

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.