2 reasons: 1. the project I am on already uses an SQL Server database. The express version is just for the dev version on my laptop. 2. I'm very familiar with SQL Server and have a few years experience using it (older versions though). The end result for this app will be 2 SQL Servers that talk to each other (DTS). One sql server in an internal office network where data is collected through an MS Access interface in the office then data is de-normalized and DTS'd to the sql server on the same network as the website (every night). Then I'm going to use CF to do a web based search interface where users of the website will be able to search and get the data.
If anyone else has an alternate suggestion, I'm happy to listen. I have been using mysql for my sites that run on Linux with PHP but just do basic stuff with it. Dusty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, April 13, 2007 12:21 AM To: [EMAIL PROTECTED] Subject: Re: [ACFUG Discuss] developing cf apps with sql server express databases Just out of curiosity why go with SQL express when you can run mysql with no limitations? -Steven On 4/12/07, Dusty Hale <[EMAIL PROTECTED]> wrote: > > > I downloaded Express for the hey of it since it's free. Seems pretty cool. > Took me a minute or too to get a DSN working through CFadmin. I'm > using "Management Studio Express" as the admin tool. Doesn't seem to > provide an easy way to import/export data or DTS. > > I also tried to use the restore feature to bring an older sql sever > database back to life (from device) but that bombed of course. > > ________________________________ > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. > Payne > Sent: Thursday, April 12, 2007 10:00 AM > > To: [EMAIL PROTECTED] > Subject: Re: [ACFUG Discuss] developing cf apps with sql server > express databases > > > DTS from SQL Server 2000 can connect to SQL Server 2005 databases if > you do not have SSIS. I have used that on more than one occasion to move data. > > > > On 4/12/07, Dusty Hale <[EMAIL PROTECTED]> wrote: > > > > > > That's what I thought and hoped ... many thx > > > > ________________________________ > From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of Dean H. > Saxe > > Sent: Wednesday, April 11, 2007 10:29 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [ACFUG Discuss] developing cf apps with sql server > > express > databases > > > > > > > > Yes and yes. You should be able to move your schema over seamlessly. > > > > > > > > > > > > > > > > > > Dean H. Saxe, CISSP, CEH > > > > [EMAIL PROTECTED] > > > > "Great spirits have often encountered violent opposition from weak minds." > > > > --Einstein > > > > > > > > On Apr 11, 2007, at 10:23 PM, Dusty Hale wrote: > > > > > > Anyone use SQL Server Express for developing CF apps on a local PC > > with > windows XP Pro? Is this a good (cheap) solution for a development > platform if the live platform will have SQL Server 2005? Will a > database developed with SQL Server Express port over well and is the > Interface for SQL Server Express similar to Enterprise Manager? > > > > Thx, > > > > Dusty > > > ------------------------------------------------------------- > > To unsubscribe from this list, manage your profile @ > > http://www.acfug.org?fa=login.edituserform > > > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > > List hosted by FusionLink > > > ------------------------------------------------------------- > > > > > > > ------------------------------------------------------------- > > To unsubscribe from this list, manage your profile @ > > http://www.acfug.org?fa=login.edituserform > > > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > > List hosted by FusionLink > > > ------------------------------------------------------------- > > > > -- > Teddy R. Payne > Adobe Certified ColdFusion MX 7 Developer Google Talk - > [EMAIL PROTECTED] > > Atlanta ColdFusion User Group - http://www.acfug.org Atlanta Flash & > Flex User Group - http://www.affug.org > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > ------------------------------------------------------------- > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > ------------------------------------------------------------- -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
