We have a legacey application that is running with a SQL backend. We want to end of life the old application and use SharePoint 2010 instead. In my my mind we have a few options of what we could do.
- Create an Import process to store the data we need in Lists
- Create a new Database. Import the data that we need from our application. Then hook that up to SharePoint
- Point SharePoint at our existing database.
In my mind 2 seems to make the most sense. It means we won't need to write a complex routine to import data. We can drop the tables we no lonnger need.
Would you agree. Is there anything else that I may need to consider.