Post reply

Transfer of a View creates a Table

  • June 3, 2005 at 6:02 am

    #68008

    Hi all,

    I am developing a VB6 package to allow our live server to be updated overnight from our staging server with any updates to DTS packages, Stored Procedures, Tables, Views, etc.

    My problem is that when I attempt to transfer a View, it always creates a Table of the same name containing all the data instead. I have also tried this in EM using the Export Wizard and un-checking different options (including the Copy Data checkbox) but it still creates a Table.

    All I want to do is to be able to copy over the View structure. Am I being incredibly stupid or is this a "feature" of DTS ?

    Any comments, whether or not regarding my stupidity, will be very welcome.

    Thanks,

    Andy.

  • June 3, 2005 at 6:28 am

    #562847

    Well, (based off of this) you are NOT stupid or crazy (of course NOT medical professional if you think you may be please contact local doctors )

    I believe this is a "FEATURE" (not a good one though)... IF you want to "move" VIEWs you will need to SCRIPT the DDL and then install it.   I am sure someone here has already posted (or will post) some nice code that will do this for you



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 3, 2005 at 9:31 am

    #562955

    Thanks for the info, and vote of confidence, AJ Ahrens.

    I will keep an eye out for the DDL script to do this.

    Regards,

    Andy.

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

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