The sql is not the same. Access and mysql are different. It's been a while
since I used SQL 2000.
I'm sure there are some difference.
gil midonnet
-----Original Message-----
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 5:29 PM
To: CF-Talk
Subject: RE: web hosting, sql 2000
You can use tools locally, and then dump the creation script to plain SQL,
and then run that on the production server. Doing things that way also
assures that you have a repeatable process (because you're using a script,
not a series of user interactions), which is a must in a cluster, and
desirable even on single machines, because it lets you test the script and
be assured that it'll happen exactly the same way on the production
machine.
Cheers
barneyb
> -----Original Message-----
> From: mayo [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 17, 2004 2:21 PM
> To: CF-Talk
> Subject: RE: web hosting, sql 2000
>
> Yes,
>
> worse comes to worse I would script it via CF. I'm
> comfortable doing that to
> add and drop a table or a couple fields. But this will have
> 15-20 tables. I
> would rather have Enterprise Manager / phpmysql sort of overview.
>
> And yes, I suppose I could build my own. ... But why reinvent
> the wheel?
>
> Gil Midonnet
>
>
> -----Original Message-----
> From: Doug White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 17, 2004 5:04 PM
> To: CF-Talk
> Subject: Re: web hosting, sql 2000
>
>
> You can also set up your tables via CF script from the web
> site. via ODBC
>
> ======================================
> Stop spam on your domain, Anti-spam solutions
> http://www.clickdoug.com/mailfilter.cfm
> For hosting solutions http://www.clickdoug.com
> ======================================
> If you woke up breathing, congratulations! You have been
> given another
> chance!
>
> ----- Original Message -----
> From: Tim Laureska
> To: CF-Talk
> Sent: Wednesday, March 17, 2004 3:36 PM
> Subject: RE: web hosting, sql 2000
>
> Adam... have you experienced that, I haven't but I'm new
> to crystaltech
> and SQL server ... do you have a better suggestion?
>
> -----Original Message-----
> From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 17, 2004 4:24 PM
> To: CF-Talk
> Subject: Re: web hosting, sql 2000
>
> yeah, if you dot mind crashing enterprise manager when it
> tries to load
> the 500+ databases they put on each server.
>
> -adam
> > -----Original Message-----
> > From: Tim Laureska [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, March 17, 2004 09:27 PM
> > To: 'CF-Talk'
> > Subject: RE: web hosting, sql 2000
> >
> > If I'm understanding you correctly, www.crystaltech.com
> will work
> >
> > -----Original Message-----
> > From: mayo [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, March 17, 2004 4:16 PM
> > To: CF-Talk
> > Subject: web hosting, sql 2000
> >
> > I have a client that's going to need something more robust than
> Access.
> >
> > Does anybody know of an ISP that has database admin tools like
> > Enterprise
> > Manager on line, something like phpmyadmin for SQL 2000.
> >
> > All I want to do is to set up the tables.
> >
> > thx
> >
> > Gil Midonnet
> >
> >
> >
> >
> >
> >
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
