We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData.

If we migrate our database from one location (in Oracle) to another (e.g. in SQL), and then re-write the web service (on-premise) to connect to the new location, will this impact the existing data rendered in SharePoint?

This would be the exact same data, just migrated to a new environment. I wouldn't guess it would change anything on the SharePoint side cause its just going out to that same external content type / web service location and doesn't care what the back-end looks like.


1 Answer 1


Provided that BCS is connected to the web service and not to the DB directly, you should not need to worry about any changes at all.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.