There are a couple of differences in how access and SQL Server deal with some of their datatypes. For example, the date format for SQL Server is 'yyyy-mm-dd', but the date format for Access is (IIRC) 'mm/dd/yy'.
I remember having some problems with moving from Access memo fields to SQL Server text fields, too. I needed to use a stored proc to do large text inserts on SQL Server. The text was getting truncated at 8k if I just went through ODBC, w/o using a stored procedure. With the SP, you can insert multiple Gigs of text. If you'd like the SP's I used, let me know. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -----Original Message----- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:58 AM To: CF-Talk Subject: Access -> MS SQL script? 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- Thanks, Lou Klepner ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
