• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Administering Databases with... > Generating T-SQL Scripts to Clone Da...

Generating T-SQL Scripts to Clone Database Objects

Another interesting SQL feature that you access from Enterprise Manager's All Tasks context menu is the capability to generate T-SQL DDL scripts to re-create all objects of a selected database. Enterprise Manager's Copy Database Wizard is a much simpler method for cloning a database, and it offers the additional advantage of optionally adding current data to the tables. Access 2002's Copy Database File and Transfer Database features are similar to those offered by the Copy Database Wizard, but they're restricted to the database for the currently open project.

→ To review Access's Transfer Database feature, see “Transferring the Project's Database to a Server” .


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint