How to migrate SQL DB to SharePoint DB.. RRS feed

  • Question

  • We have a CMS project which is developed in .Net and which has huge traditional SQL DB..Now the CMS site will be developed in SharePoint2010 using same DB..What should be the best pratices for this..Should we continue with same SQL DB and use DB using BCS or migrate it to SharePoint DB
    Shrikant Datke SharePoint Server 2010 MCITP| Developer| Administrator Blog: http://shrikantdatke.blogspot.com
    Wednesday, August 3, 2011 6:19 AM


  • Hi dake1,

    I'd say there's no need to migrate (in terms of moving data to sharepoint's db). What you can do is, use SharePoint's content db as it is and also have your db side by side in the same SQL instance and have your application configured to use both depending upon task at hand.

    But this again depends on what part of your CMS you want sharepoint to handle (an example would be Search) in which case some of your modules will be obsolete/not used and you have to very carefully plan this out.

    A random burst of technology notes Blog: http://rhythmiccoding.blogspot.com
    Wednesday, August 3, 2011 9:40 AM