Post reply

Can we script table changes?

  • July 29, 2009 at 11:24 am

    #385079

    Hi,

    I'm using SQL Server 2005. I have opened a table from management studio, and updated some rows in different columns. Now I want a T-sql script what ever I updated. Do we have any option to script out these changes??[as we do when perform backups from management studio through the wizard and at the end we can generate the script (Using Script option in the wizard)]

  • July 29, 2009 at 11:31 am

    #1031920

    There should be a save button that has a disk and a scroll looking icon...

    That scripts what ever change you have made since you opened the edit screen

  • July 29, 2009 at 11:43 am

    #1031924

    Thanks,

    I tried to find out the Icon but I did not find it. Could plz send a screen shot?

    I attached a screen shot, in that I have changed column i value from 1 to 2, now which icon I need to use to generate the script?

  • July 29, 2009 at 12:40 pm

    #1031953

    You need the "Generate Change Script" icon. Your toolbar settings are different from mine, but once you find it, click it before you finalize your table changes. It will build a script and also give you a check bot that will give you a script option ever time you make changes .... then you don't have to remember to go looking for it each time.

    Scripting changes is useful for logging changes that were made and for making repetitive changes without retyping much and risking typos.

  • July 29, 2009 at 1:09 pm

    #1031980

    Its part of the table designer toolbar.

    Click View | Toolbar | Table Designer

    Try removing and re-adding (it may appear on the far right, so moving other other about should show the tb you require)

    Its also available from the "Table Design" menu, but is only enable once you have made changes

  • July 29, 2009 at 1:47 pm

    #1032002

    thanks,

    I have opened a table in Management studio and changed some row valuse in some columns manually. Now what ever action I did, I want to see it in a T-SQL from.

    I did found the generate change script option and it is enabled(please see the attachmnet). Now After making changes to the table which icon should use to generate the script?

  • July 29, 2009 at 1:59 pm

    #1032006

    The scripts that have been mentioned before are to script data structure changes, and not data changes per se. Unfortunately there is no feature in SSMS to capture data changes and replay them via a script.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • July 29, 2009 at 3:11 pm

    #1032039

    OK ,I got it now..thanks

Viewing 8 posts - 1 through 7 (of 7 total)

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