Re: copy a database from server to development

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 06/07/04


Date: Mon, 7 Jun 2004 08:47:18 -0700

This is really a subset of detach/attach, but with the
benefit of a graphical interface. Actually this is useful
to know because it means it is also an out-of-hours
procedure, unlike backup/restore.
Regards,
Paul Ibison



Relevant Pages

  • Re: Dev to Prod
    ... generate scripts, some with data on below line: ... Also, backup/restore or detach/attach is an option, but you need to handle ... > I am building a new database in a Development environment (tables, ...
    (microsoft.public.sqlserver.server)
  • Add new table for replication
    ... then synchronize. ... the graphical interface in the article properties dialog ... Paul Ibison ...
    (microsoft.public.sqlserver.replication)