Efficient Table Migration to a New Schema in T-SQL

• Parthprajapati

  SSC Veteran

  Points: 252

  More actions

  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

• MMartin1

  One Orange Chip

  Points: 27841

  More actions

  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.

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