Ya I figured as much. I'll do a little research to see how tough a migratation from SQL Server 2000 in a shared environment up to a col-lo server with MSDE (normally I would go full-blown SQL Server on the co-lo box, but cost is an issue and the 2 GB DB size isn't an issue...but file size is...which is usually at a premium in shared hosting packages).
Anyways....looks like there are some significantly lower cost options that still allows the use of SQL Server in it's various forms....and that makes me a happy camper ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Doug White" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 10:36 AM Subject: Re: RE: MS SQL Server vs. MySQL > I think you could only do that on a co-lo or dedicated server - On a shared > environment you will run into licensing issues. Also concurrent connection > limits. > > However, the fee for using a SQL2k db in a shared environment is usually very > minimal, from a provider point of view. > > ====================================== > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf > ====================================== > If you are not satisfied with my service, my job isn't done! > > ----- Original Message ----- > From: "Bryan Stevenson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, August 25, 2003 11:08 AM > Subject: Re: RE: MS SQL Server vs. MySQL > > > | Hey Jeff, > | > | Great...thanks for the info. I'm certainly starting to think that MSDE will > | be a great alternative for our smaller clients. > | > | Now it sounds like it's totally free?? any licenceing issues? > | > | Does anybody know of ISPs that will host MSDE DBs? or is generally used for > | apps running co-lo or dedicated servers? > | > | TIA > | > | Cheers > | > | Bryan Stevenson B.Comm. > | VP & Director of E-Commerce Development > | Electric Edge Systems Group Inc. > | t. 250.920.8830 > | e. [EMAIL PROTECTED] > | > | --------------------------------------------------------- > | Macromedia Associate Partner > | www.macromedia.com > | --------------------------------------------------------- > | Vancouver Island ColdFusion Users Group > | Founder & Director > | www.cfug-vancouverisland.com > | ----- Original Message ----- > | From: "Jeff Lucido" <[EMAIL PROTECTED]> > | To: "CF-Talk" <[EMAIL PROTECTED]> > | Sent: Monday, August 25, 2003 9:02 AM > | Subject: RE: RE: MS SQL Server vs. MySQL > | > | > | > Bryan: > | > > | > 1. Yes, I use Enterprise Manager to connect to several MSDE databases > | > running at client locations. > | > 2. Yes, MSDE can be found on both the Office 2K and XP Professional > | > CD's. You can also download a new instance by downloading MSDE SP3 from > | > Microsoft. I just did it as a test this past week where I had no > | > previous install of MSDE and I ran MSDE SP3 and it installed a brand-new > | > instance for me. > | > > | > Hope that helps! > | > > | > Good luck, > | > -JSLucido > | > > | > -----Original Message----- > | > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > | > Sent: Monday, August 25, 2003 10:44 AM > | > To: CF-Talk > | > Subject: Re: RE: MS SQL Server vs. MySQL > | > > | > > | > Just wondering from those that use MSDE.... > | > > | > 1) Can Enterprise Manager from a licenced copy of MS SQL Server connect > | > to a remote MSDE DB? > | > > | > 2) Can you get MSDE seperate from the Standard or Enterprise versions of > | > MS SQL Server (because the MS site seems to say it comes with...in which > | > case a client would have to cough up full price for a full-blown version > | > = no benefit)? > | > > | > TIA > | > > | > Cheers > | > > | > Bryan Stevenson B.Comm. > | > VP & Director of E-Commerce Development > | > Electric Edge Systems Group Inc. > | > t. 250.920.8830 > | > e. [EMAIL PROTECTED] > | > > | > --------------------------------------------------------- > | > Macromedia Associate Partner > | > www.macromedia.com > | > --------------------------------------------------------- > | > Vancouver Island ColdFusion Users Group > | > Founder & Director > | > www.cfug-vancouverisland.com > | > ----- Original Message ----- > | > From: "Josh Remus" <[EMAIL PROTECTED]> > | > To: "CF-Talk" <[EMAIL PROTECTED]> > | > Sent: Friday, August 22, 2003 12:09 PM > | > Subject: RE: RE: MS SQL Server vs. MySQL > | > > | > > | > > It does include osql if you just need shell-type/command-prompt SQL > | > access. > | > > We have licenses for SQL Server, so I do use Enterprise Manager to > | > > manage our MSDE databases. > | > > > | > > > -----Original Message----- > | > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > | > > > Sent: Friday, August 22, 2003 1:49 PM > | > > > To: CF-Talk > | > > > Subject: Re: RE: MS SQL Server vs. MySQL > | > > > > | > > > > | > > > but to > | > > > > get the 2k version, you need either MSDN, Sql server 2k, or Office > | > > | > > > > XP. > | > > > > | > > > Yeah, it looks that way now. Funny, I went to their site a couple > | > > > of months ago and downloaded from there. Those wacky MS guys. > | > > > > | > > > One thing: MSDE comes with no front end tools, so you'll need > | > > > either the client tools from Enterprise Manager, or Access, or a > | > > > third party front end. One might be better off getting a developer > | > > > license for SQL Server, which is now only $49. There was a thread > | > > > about it a while ago. > | > > > > | > > > > | > > > | > > | > > | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
