Test Database Copy

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Justin Allen
    #1

    Test Database Copy

    I am using SQL 2000, 2000 Server. I need to find out how to schedule a
    database export import. I have a production database that I need to
    easily copy to a test database occassionaly. When I run the DTS
    function it won't import the primary keys. It errors. I need to get
    all the tables and views from one database into the temporary database
    that we use for testing without recreating the temp everytime. Any
    suggestions?

    Justin
    Tags: None
    • Simon Hayes
      #2
      Re: Test Database Copy


      "Justin Allen" <contactjustina llen@hotmail.co m> wrote in message
      news:3b993d0.04 02130422.7ffc0f 72@posting.goog le.com...[color=blue]
      > I am using SQL 2000, 2000 Server. I need to find out how to schedule a
      > database export import. I have a production database that I need to
      > easily copy to a test database occassionaly. When I run the DTS
      > function it won't import the primary keys. It errors. I need to get
      > all the tables and views from one database into the temporary database
      > that we use for testing without recreating the temp everytime. Any
      > suggestions?
      >
      > Justin[/color]

      The easiest way is probably to backup the database, copy the backup file and
      restore it. See "Copying Databases" in Books Online.

      Simon


        Comment

        Previous template Next
        Working...