DTS Question

Results 1 to 2 of 2

Thread: DTS Question

  1. #1
    Join Date
    Dec 1969

    Default DTS Question

    If one has a lot of stored procedures, triggers, constraints and indexes, can one use DTS to copy a database from one server to <BR>another. In addition, how is this different than detaching <BR>and attaching the LDF and MDF files for a database. <BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: DTS Question

    I only know about SQL 2000. You can right click on a database, select All Tasks -&#062; Export Data, then set up the source and destination locations and copy whatever DB objects (tables, sprocs, etc.) you need from the source to the destination. Just remember that if you overwrite an existing object with data in it, that data will be lost.<BR><BR>Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts