Forum Discussion
Incremental refresh for two sources with append query
We have three years of business data now, recent 2 years of data will always in the mysql database and other years will be stored in sharepoint (currently 1 year data) on the next year in sharepoint there will be 2 years of data and in mysql database there will be 2 years of data, it will be continuing.
No we want to append both the data from mysql database and sharepoint. I would like to import sharepoint and incrementally refresh the data from mysql database is it possible.
please provide your suggestion on this.
2 Replies
what prevents you from storing all the data in the SharePoint?
lbendlin , we are having the sql db for connecting with web application. we have planned to purge data from main db and storing the purged data in sharepoint
