633
Chapter 23: Transferring Databases
23
■ (^) The Copy Database Wizard is useful for copying or moving one or more databases
from one server to another on the same network.
■ (^) To copy only a few tables from one server to another or copy data to and from any
data source for which a managed .NET Framework data provider or a native OLE DB
provider is available, use the Import and Export Wizard.
■ Use Management Studio to quickly generate scripts to distribute database schemas,
security, jobs, and limited data.
■ Use Data-Tier Applications (DAC) to quickly encapsulate database projects for easy
deployment and upgrades. Use DACPAC to encapsulate both schema and data, if
your database objects are supported.
c23.indd 633c23.indd 633 7/31/2012 9:25:23 AM7/31/2012 9:25:23 AM
http://www.it-ebooks.info