I'm developing a CF site using Access 2000. I have access here to SQL Server 2000. The client's server, where the whole thing will end up, is using SQL Server 7.
What'll be the easiest way to upsize my Access DB once I'm ready to go live? The client want me to give me SQL scripts for generating the SQL 7 DB, with TXT files to import once the tables have been created. I'm not very SQL Server-savvy, so I'm just looking for suggestions. I noticed in SQL 2000 there's an option to limit functionality to SQL 7-level stuff - could I set this option, upsize to SQL 2000, and just give them the DB files? Of course I'd like to give them the MDB file and let them just upsize it into their SQL 7, but I'm not sure if they've got Access 2000 and they don't seem to keen... *Any* suggestions would be welcome! cheers, - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get Your Own 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=coldfusionb 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