Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chapm4
Yak Posting Veteran
58 Posts |
 Posted - 2006-07-01 : 13:46:25
|
| Hi All,I realize some of these questions might not belong exactly in theis forum, but some do and I want the developers opinion.In the past (3 years ago) I worked with SQL server for a major US corporation. We didn't perform administrative functions at the server level but wrote queries and designed reporting front ends.I have recently taken over a project as a consultant that sounds fairly simple but I have been out of it for a couple of years and need some assistance.This company has a points rewards system for customers who send in product comment cards. The database is in Access with an ASP front end in which employees enter data and view reports. The database now has 14000 records and is very slow when accessing. They are unhappy with the original programmer and have asked me to step in.Now they are purchasing a Dell glorified workstation running xp professional and will put sql server on it. They want the database redone in sql. The issue is I am 250 miles away so the questions are:1. Can I remotely do this and also have administrative access to the xp as well as the sql (if given those rights of course)?2. What version of sql would you recommend for five users and this number of records?3. can I still use the existing ASP without too many changes? (I an a PHP and MYSQL guy the last few years)Thanks for the tips. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-01 : 14:26:43
|
| It sounds like the database is will be fairly tiny, so SQL Server Workgroup or Standard edition should be fine. However, they only run on Windows Server, not XP. Also, XP is not licensed to be a server. You could also consider SQL Server Express.You should be able to administer the server remotely, provided you have a good network connection, and you know what you are doing. Obviously, you will not be able to do things like cycle the power button.I won't ask about things like tape backups, server power, security, etc. It sounds like they probably don't know, (or care) too much about that if they are planning on running a desktop computer as a server.If you have a lot of SQL Server development to do, you can get the SQL Server Developers Edition for about $50, and install it on your local computer. Then you can do your SQL development work locally, and just access the remote computer when you need to. In fact, I would recommend this approach.I can’t comment about ASP, but SQL Server and Access are very different, so you should plan on significant effort to convert it.CODO ERGO SUM |
 |
|
|
chapm4
Yak Posting Veteran
58 Posts |
Posted - 2006-07-01 : 19:26:11
|
| Thanks for the comments. The reason we were going with XP Pro was that the requirements for the 2005 Workgroup Edition on msoft.com states we can use xp pro with service pack 2.I really like the idea about the Developer Edition though so I will probably do that. So that gives me the full capabilities to develop on my machine and then just send the files to the Workgroup machine?Also does anyone else have an opinion on the ASP front end? I hate to start from scratch in vb.net or anything. |
|
|
|
|
|
|
|
|
Questions for new project