> Hello Fellow CF'ers, > > I was wondering if anyone knew of a script that would analyze a Access > Database and replicate the structure in SQL? Something which loops through > the tables, checks data types, and creates a MS SQL version of the database- >
You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and then click on Import under the sub-menu. Follow the instructions in the DTS Import Wizard and you're away. ;o) Regards Stephen ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists