Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Unanswered: copy struture of tables without loosing data

    HI

    I need to copy the table structures from my production database to development database but not loose the data in developement. Is there a way to achive this by creating some scripts.
    thanks

  2. #2
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63
    You want to copy some tables from your production environment to devleopment? If so have you tried DTS?

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447
    In your approach, you need to prevent to re-create your tables, and you simply have to append the data. DTS is the most suitable tool, there are other ETL tools as well, and, not recommended, you can write your transformation process in a varity of languages.

    I'd be glad to hear your approach.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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