Ok, I maybe confused everyone a little. Let me clarify my problem a little.
I have an ODBC source which is an Access mdb. I want to go into a p/w
protected folder and run a template that does the following.
Scenario:
data source1 = database1
tables: table1,table2
data source2 = database2
tables: table1, table2 (all records deleted at start of process)
Copy all records from all tables in data source1 (database1)
to empty data source2 (database2)
what I basically want to do is mirror all the taables at any time
to the second odbc data source (without using CFfile)
If it would be easier, faster, whatever to create datasource dynamically
and then populate it, I am game for that as well, but keep in mind these
are ACCESS not SQL databases.
Terry
----- Original Message -----
From: Andy Ewings <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 8:38 AM
Subject: RE: Copying tables thru ODBC
> You will have to create the table in the destination database and then do
a
> select into although you may be able to use BULK INSERT or bcp. I've
never
> tried it where the data's coming from a SQL table. Note that when you use
> the DTS import wizard to import data from one SQL database to another it
> goes through the process of creating the table first and then importing
> implying that you will have to do the same.
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 419 4235
> ------------------------------------------------------------------
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -----Original Message-----
> From: Simon Horwith [mailto:[EMAIL PROTECTED]]
> Sent: 16 January 2001 16:06
> To: CF-Talk
> Subject: RE: Copying tables thru ODBC
>
>
> you need to use SELECT INTO syntax to copy into another table.
>
> ~Simon
>
> > Simon Horwith
> > Allaire Certified ColdFusion Instructor
> > Certified ColdFusion Developer
> > Fig Leaf Software
> > 1400 16th St NW, # 220
> > Washington DC 20036
> > 202.797.6570 (direct line)
> > www.figleaf.com
> >
>
>
> -----Original Message-----
> From: Terry Troxel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 9:32 AM
> To: CF-Talk
> Subject: Copying tables thru ODBC
>
>
> Can anyone give me an example on how to copy a table from one ODBC data
> source to another remotely using Cold Fusion calls?
>
> Sure would appreciate it.
> Terry Troxel
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
