Access to SQL
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8906
Printed Date: 07 April 2026 at 12:44pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access to SQL
Posted By: Scotty32
Subject: Access to SQL
Date Posted: 14 January 2004 at 4:16pm
|
hi, ive decided to move webhosts so i can get a MS SQL database but one things stopping me from buyin the other webspace.... if i swop hosts... and upgrade my site (which is on Access) to a MS SQL database will it still work? by that i mean the mods...... ive changed my site quite a bit, and basically built a portal based on the forum (thats allowed right? since am not releasing it? and since i dont know alot about ASP am not sure if it will still work ive used the "SELECT * FROM table WHERE field = string" does this all still work in SQL? or would i have to try and convert my whole site to MS SQL coding for it all to work? ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
)Replies:
Posted By: WebWiz-Bruce
Date Posted: 14 January 2004 at 4:39pm
|
Most SQL is the same, there are a few differences such as in Access dates use Now() in MS SQL server you use GetDate() Access uses true/false MS SQL server uses 1/0 as it doesn't have a true fales datatype, instead in has a bit datatype. I can't think of anything else of han, but there are probally one or two. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Scotty32
Date Posted: 14 January 2004 at 4:47pm
|
so, will i be ok? if i change little stuff like that? and if i change the site to run off SQL (from the common.asp file) will it still get the fields i've added? or do i have to change sum files? ... from wot ive heard round here it sounds like the MSSQL version of the database connections run off store procedures ... would i have to change them? or not? or can i just keep the forum thinking its on Access till i work out the MSSQL? ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
