Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: copy tables along with constraints in DTS

    Hi All,

    We are using DTS tool for importing data from one database which is present in one server to another present in another server. the structure and the data is getting copied where as the constraints are not getting copied. pls suggest me as to how should i go about to to complete the job.

    waiting for ur reply.

    TIA
    regards
    Adil

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What exactly are your requirements for this ? Are you copying tables/databases ... you need indexes, constraints ...

  3. #3
    Join Date
    Nov 2003
    Posts
    48
    In Enterprise Manager, right click on the database and select "All Tasks - Import/Export", ... , select "copy objects and data between SQL Server database", click on "next", you have the option to copy all database objects include constraints into destination database.
    Shianmiin

  4. #4
    Join Date
    Nov 2003
    Posts
    3

    Lightbulb Re: copy tables along with constraints in DTS

    Hi Adil,

    Would encourage you to use a free tool for DTS, which copies tables along with constraints. Please try Vaman DataServer from the following link. http://www.vaman.net/vmndataserver.asp
    You may need to login for downloading.
    Hope this helps...

    popeye.


    Originally posted by aadil
    Hi All,

    We are using DTS tool for importing data from one database which is present in one server to another present in another server. the structure and the data is getting copied where as the constraints are not getting copied. pls suggest me as to how should i go about to to complete the job.

    waiting for ur reply.

    TIA
    regards
    Adil

Posting Permissions

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