Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger.
Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck in a situation where I will need to script the SQL tables manually? Thanks again! Lou > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen > Moretti > Sent: Wednesday, February 27, 2002 10:06 AM > To: CF-Talk > Subject: Re: Access -> MS SQL script? > > > > Hello Fellow CF'ers, > > > > I was wondering if anyone knew of a script that would analyze a Acc ess > > 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 D TS > 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 > ______________________________________________________________________ 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