RE: [ACFUG Discuss] developing cf apps with sql server express databases

2007-04-13 Thread Dusty Hale
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

RE: [ACFUG Discuss] developing cf apps with sql server express databases

2007-04-12 Thread axunderwood
Yes, developing on express should be fine locally but trying to copy data may 
be a bit of a pain if you're using studio express as there's no tools for doing 
data transformations in the express version.  However, I think you can buy a 
developer copy of sql server 2005 for something like $40 (I was just reminded 
of this today).
 
Allen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dusty Hale
Sent: Wednesday, April 11, 2007 10:24 PM
To: [EMAIL PROTECTED]
Subject: [ACFUG Discuss] developing cf apps with sql server express databases


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 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

-




RE: [ACFUG Discuss] developing cf apps with sql server express databases

2007-04-12 Thread Paul Morton
http://www.microsoft.com/products/info/product.aspx?view=22
http://www.microsoft.com/products/info/product.aspx?view=22pcid=f544888c-2
638-48ed-9f0f-d814e8b93ca0type=ovr#HowToBuy
pcid=f544888c-2638-48ed-9f0f-d814e8b93ca0type=ovr#HowToBuy
Developer Edition: $49.95
 
Paul

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, April 12, 2007 5:47 AM
To: [EMAIL PROTECTED]
Subject: RE: [ACFUG Discuss] developing cf apps with sql server express
databases


Yes, developing on express should be fine locally but trying to copy data
may be a bit of a pain if you're using studio express as there's no tools
for doing data transformations in the express version.  However, I think you
can buy a developer copy of sql server 2005 for something like $40 (I was
just reminded of this today).
 
Allen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dusty Hale
Sent: Wednesday, April 11, 2007 10:24 PM
To: [EMAIL PROTECTED]
Subject: [ACFUG Discuss] developing cf apps with sql server express
databases


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 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  
- 




-

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

-




RE: [ACFUG Discuss] developing cf apps with sql server express databases

2007-04-12 Thread Dusty Hale
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
-



Re: [ACFUG Discuss] developing cf apps with sql server express databases

2007-04-12 Thread Steven Ross

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
-