Hi all, I have some code that maintains a database, and this code modifies the database through coldfusion. I have a scenario where we are doing this that often that I want to sync the development database and production database in some cases when this is done.
Is it possible to be able to generate the following via script in anyway possible. CREATE TABLE [dbo].[arRates] ( [RateCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Rate] [numeric] (9, 2) NOT NULL ) This is maybe not the best example as the table didn't exist in this case. I am able to find the right system tables but would like to know of anyone who might be able to help convert these numbers from the system tables to the above script. For alteration and creation etc. Hope I made sense, I realise I could setup the database in SQL to do this but I am looking at a solution that anyone can add to the development and when happy sync through a control panel situation. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485 - Fax: 03 9699 7976 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2195 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
