I do agree, DTS is the bomb. You can also call a DTS package through CF.
Check it out at http://www.cfcomet.com
Mark
-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 12:18 AM
To: CF-Talk
Subject: Re: Using ColdFusion to create/manipulate Database tables
At 04:57 PM 08/26/2001 -0700, you wrote:
>We have just joined a hosted environment and although we have access to
SQL
>Server via enterprise manager, we do not have the facility to
import/export
>tables via enterprise manager.
Can't you just use DTS to create the table objects via Enterprise
Manager? You should be able to use it to copy over all your tables,
including identities, triggers, default values, and I believe stored
procedures ( And just about any database object you want to )
>Can anyone point me to a resource or give some good tips on using CF to
>manipulate-add-delete tables in a SQL Database?
Well, if you want to write T-SQL to do it, you can. And that code
should run without any problems in a CFQUERY.
--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
I'm looking for a room-mate in the Hartford CT area, starting in August
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
http://www.instantcoldfusion.com
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Change is good
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
