Move the SQL 2000 shouldn't kill anyone. It would be a conversion/import of the DB, a huge find & replace task, then a decent test phase.
In perspective, I could transfer a large Witango site in about a day, unless there were a large number of "Access workarounds" which needed to be rewritten in SQL. (this would be a more likely event with MySQL or Oracle as Access and MSSQL are very similar) In my experience, however, Access is simply never worth using. Robert -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:27 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: [Off] Access to SQL with ASP I am looking for a confirmation of something to check on the skill level of a company I may be working with. They have a content management tool built in Access. It uses ASP. We want them to migrate it to SQL 2000 or MySQL. My understanding was that if the table structures were the same this would not be a complex task. They are saying it will take a lot of programming time. Who's right? -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
