Hi Dan, Converting an Access database to SQL Server is the easy part (can't speak for MySQL :-P).
The time consuming part will be the ASP code. Obviously the database connection strings will be different, then the ADO Recordsets in ASP. Their behavior may change with the upgrade. Some SQL statements may likely change from Access to SQL. It depends on how complex the application logic is I guess. Potentially this could lead to a nightmare job. Don't assume it's going to be a walk in the park. HOW TO: Convert an Access Database to SQL Server http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com: 80/support/kb/articles/Q237/9/80.ASP&NoWebContent=1 SQL Server Upgrade Recommendations and Best Practices http://www.sql-server-performance.com/jk_sql_server_upgrade.asp ----- Now, of course if they are considering upgrading their application to SQL Server - your client should consider the justification of continuing to support ASP. With ASP.NET now the defacto standard for Microsoft Web Application development - "classic" ASP has a limited life. If your client is considering an upgrade, then they should be considering a complete upgrade away from ASP as well. You'll score points by bringing this to their attention. Either your client is .NET capable (skill level high), or they're just fishing in the dark for a solution (skill level low) - in which case, this maybe your opportunity to push Witango. Best of luck.... Scott Cadillac, XML-Extranet ~ 403-254-5002 ~ [EMAIL PROTECTED] ------------ Well-formed Programming in C# .NET, Witango, MSIE and XML ------------ Weblog ~ http://xmlx.ca Forums ~ http://forums.xmlx.ca Knowledge Base ~ http://kb.xmlx.ca ------------ IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca ------------ P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 24, 2004 9: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
