Post reply

Need to extract the index schema from few dbs and need to apply them to target d

  • September 8, 2022 at 3:09 am

    #4085185

    Hello,

    Is there any handy script available to extract the index schema from a few dbs and need to apply them to target databases?

    Thanks.

  • September 8, 2022 at 7:01 am

    #4085266

    To generate such a script, launch SSDT and select Tools/SQL Server/New Schema Comparison.

    Select your source and target databases.

    Go into Settings and select only Indexes.

    Run the comparison and script out the results. I suggest that you run this script in QA first, before risking affecting Production.

    You will have to do this for every source/target database.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 10, 2022 at 11:48 am

    This was removed by the editor as SPAM

  • September 22, 2022 at 9:09 am

    This was removed by the editor as SPAM

  • September 22, 2022 at 1:21 pm

    #4090791

    thanks, Phil. This is a great approach.

    Thanks.

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

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