Dusty,
I have an MSDE version of SQL 2000 and 2005 Express running on my laptop.
I will start the 2000 server and then get into my DTS stage. As long as you
know port and server location, you can connect a SQL data source connection
from 2000 to 2005.
I have actually connected two 2005 data sources in one DTS to pump schema to
schema.
SQL Server 2005 also offers an import of Sybase, Oracle and Access.
Steve,
Does MySQL have an ETL language tool?
Teddy
On 4/13/07, Dusty Hale <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------
--
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 http://www.fusionlink.com
-------------------------------------------------------------
