Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: sql server 2000 database

    We have a website hosted on the intranet of our company . Now we have to host on the internet . The database is sql server on the intranet and will still be sql server when it is hosted on the internet . Any suggested ideas how this can be accomplished. I have been asked to use DTS packages . Can any tell me the process of accomplishing this process . Can I use replication at any stage of this process ?
    Responses are appreciated !!!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You want to move the database from one SQL Server 2000 instance to another? If so just backup your internal database, ftp it to the hosted server and restore it there.
    Replication is for maintaining two copies of a database simultaneously. DTS is for ETLing data, not moving a database in its entirety.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Don't forget to bring over logins, and fix them following the DB restore.
    look at:
    sp_change_users_login

Posting Permissions

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