Importing database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • shilabhadra
    New Member
    • Sep 2007
    • 1
    #1

    Importing database

    I have two database in server name comp1,such as : ayush and test. I have created some tables in ayush database. No tables done at test,having only default tables and other defaults. I want to transfer all tables with data from ayush to test completely. I have tried in import and export wizard,but in programming language it gives error, that database cannot fetch in forward direction. Please help to solve this problem.
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Originally posted by shilabhadra
      I have two database in server name comp1,such as : ayush and test. I have created some tables in ayush database. No tables done at test,having only default tables and other defaults. I want to transfer all tables with data from ayush to test completely. I have tried in import and export wizard,but in programming language it gives error, that database cannot fetch in forward direction. Please help to solve this problem.
      Option1: use enterprise manager. either export from ayush or import to test...

      Option2: backup the entire ayush db. restore it as test

        Comment

        Previous template Next
        Working...