a few questions befor i convert 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=14540
Printed Date: 12 April 2026 at 8:42pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: a few questions befor i convert to SQL
Posted By: simon121
Subject: a few questions befor i convert to SQL
Date 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 ------------- http://pakapaka.info/forum"> 
|
Replies:
Posted By: dj air
Date 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. |
Posted By: simon121
Date 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.. ------------- http://pakapaka.info/forum">
|
Posted By: dj air
Date 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 |
Posted By: Paul Lush
Date 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. |
Posted By: dj air
Date 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. |
Posted By: simon121
Date Posted: 05 April 2005 at 1:38pm
ok so i want to convert, but i dont know how 
what is the Enterprise Manager for the SQL Server? ------------- http://pakapaka.info/forum">
|
Posted By: dj air
Date 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 |
Posted By: simon121
Date Posted: 05 April 2005 at 3:50pm
|
yes but steel i didnt understand what is the enterprise manager, what to do with this and how to use it im stuck  ------------- http://pakapaka.info/forum">
|
Posted By: snooper
Date Posted: 05 April 2005 at 4:45pm
| its just like the MS Access interface |
Posted By: simon121
Date Posted: 06 April 2005 at 4:37am
|
from where i can get it? ------------- http://pakapaka.info/forum">
|
Posted By: xeerex
Date Posted: 06 April 2005 at 9:37am
You will need a copy of MS SQL Server in order to get Enterprise Manager. It ships with MS SQL Server. Also, you may want to check with your host. Many do not allow connections through Enterprise Manager, but give you a web-based interface instead. When you install SQL Server to your local Windows developer/testing pc (Win2k Pro-Server-Adv Server, WinXP Pro, Win2003), Enterprise Manager will be installed as well. Helpful Links: Learn SQL Server 2000 Administration in 15 Minutes a Week Series http://www.databasejournal.com/features/mssql/article.php/1457321 - http://www.databasejournal.com/features/mssql/article.php/1457321 MSDE 2000 Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that’s ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users. http://www.microsoft.com/sql/msde/default.asp - http://www.microsoft.com/sql/msde/default.asp Hands on how to configure the Microsoft MSDE http://www.codeproject.com/database/ConfigureMSDE.asp - http://www.codeproject.com/database/ConfigureMSDE.asp Other Notes: SQL Server Enterprise Edition Up to 32 Processors Up to 64 GB of Memory Maximum database size 1,048,516 terabytes SQL Server Standard Edition Up to 4 Processors Up to 2 GB of Memory Maximum database size 1,048,516 terabytes MSDE Up to 2 Processors Up to 2 GB of Memory Maximum database size 2 GB ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
wrote:Posted By: Gullanian
Date Posted: 06 April 2005 at 10:21am
| You can get the evaluation copy of MS-SQL Server 200 from microsofts site, around 300MB, and it comes with Enterprise Manager. |
Posted By: simon121
Date Posted: 06 April 2005 at 10:57am
|
ok thanks for the explain but im opening the sql on the server not on my local pc
is there a possibilty to connect to the database from the Enterprise Manager? ------------- http://pakapaka.info/forum">
|
Posted By: dj air
Date Posted: 06 April 2005 at 11:00am
|
yes you can connect via Enterprise manager to any server you have access to you need the location for example mssql3.emagineservers.co.uk) then you need a username and password. i did try to contact you via MSN to let you know but i have not seen you online. |
Posted By: Gullanian
Date Posted: 06 April 2005 at 11:59am
| Thats why SQL-Server is so good, you can use it from anywhere! |
Posted By: simon121
Date Posted: 06 April 2005 at 2:14pm
------------- http://pakapaka.info/forum">
|
Posted By: simon121
Date Posted: 07 April 2005 at 10:47am
|
i have SQL server enterprise 2000 <-- edit --> sorry instead of replying to a post i clicked edit. i have added what i can remeber from your post <--/Edit--> ------------- http://pakapaka.info/forum">
|
Posted By: simon121
Date Posted: 10 April 2005 at 11:52am
|
help me plz ------------- http://pakapaka.info/forum">
|
Posted By: dj air
Date Posted: 10 April 2005 at 12:09pm
|
does enterprise manager come with that package? if so you need to set up a account profile within "Client Network Utility" this holds the name/ip of the server and username and password then when in Enterprise manager you select add new server/registration. a list will apear you can create a new one or as i did use the one you created in "Client Network Utility" select that.. click ok.. then it should have a little server icon on the screen double click that and you are then establishing a connection to the SQL server If you turn MSN on when you are online i most likely will be online, i am most the time. I will 99.99% be online today at 21:00 (BST) bristish summer time but if your not i will be on again most the day tomorrow.. i am online/computer most of the day every day |