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
    Posts
    5

    Lightbulb

    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
    Posts
    40
    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
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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.
    Sam
    Thanx
    Sam



    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