Post reply

Transferring views from 2000 to 2005

  • January 20, 2009 at 6:17 am

    #130304

    I want to transfer some views from 2000 to 2005, i have tried using the wizard, but all this seems to do is create a table populated with the data returned from the view. I know i create a new view then just copy and paste the SQL script. bUt i'm sure there must be an easier way.

  • January 20, 2009 at 6:35 am

    #929687

    Personally, I would use the generate script task to script the views into a file and then execute the script on the new server.

    As an alternative you can use the transfer database objects task in DTS or SSIS.

    [font="Verdana"]Markus Bohse[/font]

  • January 20, 2009 at 7:01 am

    #929712

    Thanks for that, i guess i will probably go down the 'generate script task to file' route, it should save some time.

    Regards

    Barry

  • January 20, 2009 at 10:03 am

    #929791

    Good advice. Since the Transfer Objects Task is no longer available in the Import/Export Wizard, scripting is the easiest way to copy views.

    Greg

Viewing 4 posts - 1 through 4 (of 4 total)

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