Post reply

Efficient Table Migration to a New Schema in T-SQL

  • November 3, 2023 at 12:00 am

    #4309306

    Comments posted to this topic are about the item Efficient Table Migration to a New Schema in T-SQL

  • November 6, 2023 at 6:52 am

    #4322045

    I have to wonder about moving tables from one schema to another and how that would impact applications accessing established data. I imagine a synonym coming into the equation at the least.

    In the case of moving "older" records, the question is can those older records still be queried ? If so a query would then have to piece together two tables. So if we really want to archive data, my thought is we dont think we would query it but maintan it just in case or for legal requirements. In such a scenario, to avoid any potential confusion, I may just move the data to a archive database.

    Thank you for this contribution. It is helpful to know this can be done.

    ----------------------------------------------------

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

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