Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - a few questions befor i convert to SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

a few questions befor i convert to SQL
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
simon121 View Drop Down
Groupie
Groupie


Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simon121 Quote  Post ReplyReply Direct Link To This Post Topic: a few questions befor i convert to SQL
    Posted: 03 April 2005 at 2:12pm
first off all, will the forum will work faster? becouse the access version is a bit slow
and sometimes its stop working for some hours
 
does this process will damage the database?
 
sorry but im a bit worry becouse i have a forum working more than a year and i heard that the sql is batter,
so i just want to know how
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 03 April 2005 at 3:52pm
yes the SQL version is faster as its not a flat file like Access

also you can ue stored procedures etc that help. and uits less likely to corrupt.


it shouldn't damage the access database or the dat within it .. there is a topic on migrating from access to SQL pinned at the top of this forum.

it is much better i would never use Access again.
Back to Top
simon121 View Drop Down
Groupie
Groupie


Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simon121 Quote  Post ReplyReply Direct Link To This Post Posted: 04 April 2005 at 1:42pm
ok sounds great! but how can i beckup it?
with the access i can do it directly from the FTP
here its diferent like you said its not a flat file..
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 04 April 2005 at 1:47pm
with most SQL hosts you can either get your host to do a .bak file and add to your webspace,

 or you can send all details via Enterprise manager to a local SQL server database or you can make a .bok file yourself i believe.

but most hosts take back ups every 24 hours .. and some (i know we do) .. will restore a database for the client on request
Back to Top
Paul Lush View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 24 September 2003
Status: Offline
Points: 59 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Paul Lush Quote  Post ReplyReply Direct Link To This Post Posted: 05 April 2005 at 4:40am
Its usually better to user the Upsizing wizard to push to SQL if you can.  The WWG SQL code isnt there for speed, its there for stability.  The stored procedures are exact copies of the Access calls and the only speed increase youll get will be based on the SQL query engine only.

For real SQL optimisations, you have to recode a large amount of the ASP code (as Ive done in the Windows security version) which adds a huge benefit of a decrease in the amount of DB opens per page.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 05 April 2005 at 6:15am
from past exsperiece and users on this forum i have found the upsizing wizard doesn't work with the forum

or at kleast you have to do a lot of fidling to correct the errors.

the best option is the pinned topic within this forum.
Back to Top
simon121 View Drop Down
Groupie
Groupie


Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simon121 Quote  Post ReplyReply Direct Link To This Post Posted: 05 April 2005 at 1:38pm
ok so i want to convert, but i dont know how Ermm
what is the Enterprise Manager for the SQL Server?
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 05 April 2005 at 2:14pm
enterprise manager is the interface used to eidt details etc , the database structure ,

you are able to add and delete/ edit records etc.. its like an access interface sort of

thiinking .. to do the tranfer you require DTS to do the actual transferring .

the below topic says about doing so.

http://forums.webwiz.net/forum_posts.asp?TID=12975&PN=1

i'd advise reading the whole topic before hand
Back to Top
 Post Reply Post Reply Page  123>

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.