Azure SQL database copy/move across subscriptions.

Поделиться
HTML-код
  • Опубликовано: 12 ноя 2024

Комментарии • 4

  • @BezKomentare
    @BezKomentare 2 года назад

    If you need to find out what is the pricing tier of the source database you can use the TSQL statement:
    SELECT d.name,
    slo.*
    FROM sys.databases d
    JOIN sys.database_service_objectives slo
    ON d.database_id = slo.database_id;

  • @BezKomentare
    @BezKomentare 2 года назад

    To find out the source database size:
    SELECT (SUM(reserved_page_count) * 8192) / 1024 / 1024 / 1024.0 AS DbSizeInGB
    FROM sys.dm_db_partition_stats

  • @adeolaadeyeye2748
    @adeolaadeyeye2748 Год назад

    Is there a way to have this scheduled , maybe automatically schedule these data copies on a daily or weekly basis ?

  • @asthagupta2783
    @asthagupta2783 Год назад

    will this copy all data in the database?