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.

  • September 22, 2022 at 1:21 pm

    #4090791

    thanks, Phil. This is a great approach.

    Thanks.

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

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