| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 39741 | 2003-11-15 22:08:00 | Which Server Operating System Setup? | Erin Salmon (626) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 192291 | 2003-11-15 22:08:00 | Hi, I've a number of websites which have outgrown using MS Access, and are starting to fall over a bit under the strain of too many connections... The solution is obviously to use MS SQL Server, but this raises a lot of questions... I can have the website hosted elsewhere on servers which have SQL Server running, but I would need to develop the sites and databases locally. Is it possible to do this on a workstation using Developer Edition? The better option, which gives me a lot more flexibility is to get a development server. I understand that MS SBS has SQL server with it, and I could use this. However, should I want to then turn the server loose on the web to host sites, would the software (SBS, or SQL Server) limit its use in this way? Is there a limit to the number of connections, or a maximum user limit? What about the software performance? If so, is my only option for such a server to use something like Windows Server 2003, with SQL Server Standard Edition (At something like $12,000...)? Thanks in advance! Erin |
Erin Salmon (626) | ||
| 192292 | 2003-11-15 22:24:00 | I would think, that if MS SQL Server Developer Edition runs as a server and has unlimited connections (it'll most likely be mentioned in the Licence Agreement upon installation if there are client limitations), then it would be best to use (because it's free, isn't it? Else you could find out if there is a MySQL to MSSQL converter (there's a MSSQL to MySQL converter), and use MySQL to develop your databases and convert them over. However, should not your host have some sort of control panel to set up databases? Oh, and do you currently have a host, or are you hosting yourself? |
agent (30) | ||
| 192293 | 2003-11-15 22:45:00 | On the mySQL theme, would it be better just to use mySQL exclusively which reduces your licence costs but means a conversion project and hosting review. Another option could be to use MSDE for a development server. |
Dolby Digital (160) | ||
| 192294 | 2003-11-15 22:45:00 | Hi, I do have a host at present, but if I'm going to set up a reasonably decent rig here to develop sites, I may as well host a few too - in which case, the software I end up chosing should be able to do that. The host I have at the moment costs for hosting the site (pretty reasonable rates), but the cost of an MS-SQL Database is $1/MB/month. I have a site in development at present (still a good 6 months from completion), which will likely have a database starting somewhere around 100MB, and growing well past 1GB over a year or so. To be paying something like $1200/month for hosting would make me think I could do it a LOT cheaper by setting up my own system. I have ample hardware already at my disposal to run a server, complete with backup systems and redundant power backup - but I need to get a grasp on what sort of software package to run on it. I need IIS 5.0 and MS-SQL Server 2000. Ideally, I want to run it on the internet as a web server, but in the meantime it would be a development server. Thanks, Erin |
Erin Salmon (626) | ||
| 192295 | 2003-11-15 23:38:00 | If MSDE can be used as an internet database server, then by all means go for it (and can someone please tell me if it's free, because I've got a copy of it on CD, which mentions nothing about it being a trial version - and another app on the CD says "trial", so I would assume it's not). Just out of interest, if your hosting company supports ASP, could you tell me who they are? |
agent (30) | ||
| 192296 | 2003-11-15 23:54:00 | > Just out of interest, if your hosting company > supports ASP, could you tell me who they are? 2day supports ASP ( 2day.co.nz) |
stu140103 (137) | ||
| 192297 | 2003-11-16 00:10:00 | 2day.com rather - I host with them at present. ASP and ASP.NET are reasonablty priced (for NZ), but MS-SQL is a rip-off... :) Erin |
Erin Salmon (626) | ||
| 192298 | 2003-11-16 00:24:00 | Looks like this may answer my question: www.microsoft.com Quote: "SQL Server 2000 Enterprise Edition and SQL Server 2000 Standard Edition are the only editions of SQL Server 2000 that can be installed and used in live (deployed) server environments. " SQL Server 2000 Standard and Enterprise Editions may only operate on a Server Operating System. With $10k down for SQL Server Standard, and $5k for the hardware and Server OS, it looks like I might do best to stick to a Development Edition for the moment. Still, one year of hosting with 2day.com would pay for both the hardware and software for that setup. Amazing how fast these things pay off... :P Erin |
Erin Salmon (626) | ||
| 192299 | 2003-11-16 01:22:00 | ... mySQL, and Apache ... ;-) | Graham L (2) | ||
| 192300 | 2003-11-16 01:39:00 | With ASP? ;) | Erin Salmon (626) | ||
| 1 2 3 4 | |||||