>OK. You discuss an application that was casually / poorly designed in the first place. Do you feel a well designed app with local data storage also needs extensive redesign when upsizing to a database such as SQL Server?
Mike,
My point in this discussion is that "UPSIZING" is much more than simply changing where the data is. To asnwer your direct question, sure any application can easily have its data moved from one data store to another and all that has to be change is the syntax of the code that accesses the data directly. However, Upsizing an application connotes more than moving where the data is stored. It means making the app able to hanlde larger amounts of data and a number of divergent front ends and more.