I have a backup of my SP2010 FBA database from SQL2008, and I want to copy the data into SP2013. I know that I can restore the database into SQL 2012, but I also know that all the user records will have the ApplicationID from my SP2010 web app, and it won't match the ApplicationID of the new SP2013 web app.
I tried to edit the ApplicationID for one record, but I cannot as this field is related to others.
Another concern I have is that we use discussion boards extensively, so keeping content author ID matching user IDs when data migrated to SP2013 is critical.
So, my questions:
- Am I missing anything simple that will allow me to use the existing data in SP2013?
- Is there a way I can change the ApplicationID across all tables within the FBA database?
- Does anyone have any steps for migrating FBA stuff between 2010 and 2013?