Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Shannon 148 posts 171 karma points
    Jan 26, 2011 @ 04:41
    Shannon
    0

    Import users and blogs from Community Server 2007

    Anyone have any SQL scripts they can share?

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Jan 26, 2011 @ 06:01
    Richard Soeteman
    0

    Hi Shannon,

    Don't have these myself but I'm interested in these scripts as well to support migration out of the box in a future release.

    So if you find out how please reply to this message or send to richard[at]soetemansoftware[dot]nl

    Thanks,

    Richard

  • Shannon 148 posts 171 karma points
    Jan 26, 2011 @ 06:17
    Shannon
    0

    How about I give you a schema of CS 2007 and we can help each other?

  • Shannon 148 posts 171 karma points
    Jan 26, 2011 @ 08:13
    Shannon
    0

    For importing blog posts from Community Server 2007, I used the following query

    SELECT Subject, PostDate, FormattedBody from dbo.cs_Posts where SectionID = 'xxxx' and PostLevel = '1'

    Where xxxx equals the sectionID listed in the dbo.cs_Sections table. To get a list of all of the blogs, use the following:

    SELECT * from dbo.cs_Sections WHERE GroupID = '13'
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Jan 26, 2011 @ 09:08
    Richard Soeteman
    0

    Thanks Shannon,

    Will use it in a future release, If your current DB contains public data and you want to share I would be very intersted to use it as a Test db.

    Cheers,

    Richard

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies