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 4036 posts 12863 karma points MVP
    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 4036 posts 12863 karma points MVP
    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

Please Sign in or register to post replies

Write your reply to:

Draft