Sign up for Office 365
Learn more about Office 365
I have Sharepoint 2010 sp1 on-premise .It uses FBA authentication and authentication information is stored in Custom sql server aspnet database .
Now i want to Move on-premise Sharepoint server to Office 365 sharepoint online.
I don't see any option to import sql database or some otherway to migrate FBA users db.
Can anyone provide or suggest steps.
you can't import directly your user accounts from SQL to Office 365 for use with SharePoint online
There only 2 options to create/manage user accounts in Office 365:
* directory synchronization : to sync your local AD with Office 365; all account management is done through AD
* office 365 user management: user account creation and management is done through the Office 365 admin portal; you can do bulk import using CSV file
according to your context, I'll recommend to export your SQL DB in a CSV file and then import it through the admin portal
Easter eggs :D
to migrate your content from your local SharePoint onto SharePoint online, you need to use a third party tool, such as Quest or AvePoint
I made a post to migrate your content using AvePoint here blog.hametbenoit.info/.../Post.aspx
Senior Solutions Architect
MVP Office 365 - MCITP Office 365 - Microsoft Community Contributor
Blog - Twitter
I just want to let you know that we built a tool MetaVis Migrator for Office 365 that can copy on-premise SharePoint sites to Office 365 SharePoint. The tool can copy entire sites with sub-site hierarchies, content types, fields, lists, list views, documents, items with attachments, look and feel elements, permissions, groups and other objects. The tool preserves created / modified properties, all metadata and versions. It looks like Windows Explorer so it will be easy to learn. It does not require any server side installations so you can do everything using your computer or any other server.
Free trial is available: http://www.metavistech.com . Feel free to contact us.
Good luck with your migration project,