Exporting and importing data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Exporting and importing data

  1. #1
    Join Date
    Mar 2001


    Is it possible to export based on last modified date? And if I can wll it be able to import into a different database with all the same fields and schema but with slightly different account information. I would like to update this with all information that was exported but lose any of the current info.

  2. #2
    Join Date
    Feb 2001
    Its is possible to export the last modified data. U can use Incremental Export. And if u have altered the structure of the tables then u have to create the modified table structure in the database in which the import is done. Any suggestions...

  3. #3
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    The way to do this is to create table xyz as select * from table_name where lastmodifiedfdate between x and y.

    Then you can export this table. and import into another user or to the same user.

    Life is a journey, not a destination!

Posting Permissions

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

Click Here to Expand Forum to Full Width