Post reply

db migration

  • May 12, 2009 at 11:10 pm

    #133870

    Hi All,

    We are planning the db migration from sqlserver 2000 to sqlserver 2005 in one of our production box soon.

    We are going for backup and restore option.

    Please help me out the following questions.

    1. What are the steps need to be taken pre-migration and post-migration.

    2. Can we configure the logshipping between sqlserver 2000 to sqlserver 2005.

    Please suggest if any good option for this request.

    Thanks, Karthik

    Kindest Regards,

    karthik

  • May 12, 2009 at 11:20 pm

    #993453

    If you are planning to migrate all databases or there is only one database in your sql server 2000, then upgrade will be a more better option.

    DBDigger Microsoft Data Platform Consultancy.

  • May 12, 2009 at 11:24 pm

    #993457

    Only one database at this time.

    what about the logshipping option in between 2000 and 2005

    Thanks,

    Kindest Regards,

    karthik

  • May 12, 2009 at 11:31 pm

    #993459

    karthikeyan (5/12/2009)

    Hi All,

    We are planning the db migration from sqlserver 2000 to sqlserver 2005 in one of our production box soon.

    We are going for backup and restore option.

    Please help me out the following questions.

    1. What are the steps need to be taken pre-migration and post-migration.

    2. Can we configure the logshipping between sqlserver 2000 to sqlserver 2005.

    Please suggest if any good option for this request.

    Thanks, Karthik

    I believe that Microsoft has some checklists and planning guides for this at their site.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • June 9, 2009 at 8:40 am

    #1006738

    We just got done this and it was a real F'ing nightmare man. Use the wizard if you can and if not then check out dts xchange from Pragmaticworks.com, thats what we used and it helped a ton. Only worth it if you got enough packages though.

  • June 9, 2009 at 11:33 am

    #1006940

    Ballad (6/9/2009)

    We just got done this and it was a real F'ing nightmare man. Use the wizard if you can and if not then check out dts xchange from Pragmaticworks.com, thats what we used and it helped a ton. Only worth it if you got enough packages though.

    Could you be more specific about which wizard to use and what parts were a nightmare to migrate?

    I ask only because I have done several SQL 2000 to 2005 migrations for different customers and most parts were very easy and simple.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • June 9, 2009 at 11:39 am

    #1006945

    I had something like 500 DTS packages that were all full of garbage (like active x) and manually doing it was killing me. I wanted to run them in compatibility mode but someone sold the boss on SSIS so I was doomed from the get go.

  • June 9, 2009 at 11:45 am

    #1006951

    Migrating DTS is not migrating a database. It is something different. And it is a pain.

    We are happy to help with questions on items, but not general ones like what do we do to log ship. Do your own research and check the MS site for procedures, as noted above.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • June 9, 2009 at 11:55 am

    #1006963

    yeah I wasn't paying attention I guess. I've been doing this project so long, when I see the word "Migrating" I have dts on the brain

  • June 9, 2009 at 12:00 pm

    #1006968

    If you have 500 DTS packages, I bet you have DTS on the headache!

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • June 9, 2009 at 12:03 pm

    #1006970

    Ballad (6/9/2009)

    I had something like 500 DTS packages that were all full of garbage (like active x) and manually doing it was killing me. I wanted to run them in compatibility mode but someone sold the boss on SSIS so I was doomed from the get go.

    Yes, I would agree with that. The current project that has been consuming so much of my time recently is the same thing. It is very time-consuming and slow going (or "Why I hate GUI development tools used a language development substitutes.")

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply