Results 1 to 2 of 2

Thread: Trouble with DTS package

  1. 05-06-2003, 11:06 PM #1
    youainttony
    youainttony is offline Registered User
    Join Date
    Feb 2003
    Location
    USA
    Posts
    2

    Arrow Trouble with DTS package

    Hello All,

    I am attempting to port a database from one server to another, I am using the DTS wizard to so this, the Db copies over to the other server but it drops the views, usernames, stored procs etc. Is there another way to do this? possibly with T-SQL? Any suggestions would be great.

    Thanks

    Tony
    Reply With Quote Reply With Quote
  2. 05-07-2003, 02:23 AM #2
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    You can use backup / restore to port a DB from one server to another:

    1) Backup Source DB
    2) Copy Backup Device to target server
    3) Restore Backups on target server
    4) Resync logins on target server / db
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules