if you're dealing with lots of tables then automating the CRUD processes of the tables is possibly worthwhile
http://www.mail-archive.com/[EMAIL PROTECTED]/msg05283.html explains CFSQLTool, if you've not come across it mind you, you're still have to handle foreign keys and referential integrety ie: it'll be an "entity" insert, not table insert, etc. of course, if it's SQLServer, you can get the create table script from saving table AND data (the Ent Mgr tool) and delete the DDL code, leaving the insert statements for each row...sloppy but do-able just an idea barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Antony Sideropoulos Sent: Friday, 1 October 2004 2:00 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] Script creator to populate db with data What databse platforms are your original and new databases? ----- Original Message ----- From: Taco Fleur <[EMAIL PROTECTED]> Date: Fri, 1 Oct 2004 12:31:48 +1000 Subject: [cfaussie] [OT] Script creator to populate db with data To: CFAussie Mailing List <[EMAIL PROTECTED]> Does anyone know of script creator that can create a script to populate a db? What i'd like it to do is look at the current data in there and create the proper INSERT statements for each record.. Its for testing purposes, we need to populate and empty the db on a regular basis, I do not want to make a backup of the db and restore it... -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
