79357858

Date: 2025-01-15 10:37:28
Score: 0.5
Natty:
Report link

Objects like stored procedures are "only available when the source and destination are different servers" [1].

What "at first blush" seems obvious is however with historical hindsight "a wrong turn".

What follows is my personal perspective and experience from following SQL Server's development since 1998.

Commands were much more prevalent historically and this new approach to use context menus were not a the foremind of programmers. CLI was The Thing originally.

Over the years Microsoft added the Copy Database Wizard, however the commands Backup and Restore were always there. And the best way to copy a whole database.

Where this fails is when only parts of a database need to be copied or just the data as safety copy. Primarily these requirements became the SSIS driven "Copy Database Wizard".

Source / References:

[1] https://learn.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard?view=sql-server-ver16

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: Knut Boehnert