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] <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 <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 <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 FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- -- 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 <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 -------------------------------------------------------------
