Professional Web Applications Themes

Transfer Data from one table to another - Microsoft SQL / MS SQL Server

Hi, I am trying to transfer some data from an old database to a new one however the table structure in the new database isn't exactly the same. I was wondering how I do this! I would also like to keep the same identity in the identity column of the old Database and transfer it into the new identity column in the new database so I don't have to work my way through the database and change all the links on my web site. I would be really grateful for any tips! Thanks...

  1. #1

    Default Transfer Data from one table to another

    Hi,

    I am trying to transfer some data from an old database to
    a new one however the table structure in the new database
    isn't exactly the same.

    I was wondering how I do this!

    I would also like to keep the same identity in the
    identity column of the old Database and transfer it into
    the new identity column in the new database so I don't
    have to work my way through the database and change all
    the links on my web site.

    I would be really grateful for any tips!

    Thanks
    MyaTiX Guest

  2. #2

    Default Re: Transfer Data from one table to another

    >> I am trying to transfer some data from an old database to a new one
    however the table structure in the new database isn't exactly the same.
    <<

    There are ETL tools for this kind transfer. you might want to download
    the freebie copy of Data Junction and see if that has wht you need.
     [/ref]
    identity column of the old Database and transfer it into
    the new identity column in the new database so I don't
    have to work my way through the database and change all
    the links on my web site. <<

    Why don't you take the time to do this right and get rid of the
    non-relational, proprietary IDENTITY properties and use real keys
    instead? Why don't you clean up the website so that the design depends
    on logical instead of physical values? This sounds like your design was
    done without any concept of a tiered C/S architecture and logicalo
    rather than physical location access to data ...

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

  3. #3

    Default Re: Transfer Data from one table to another

    Try:

    USE newdb
    SET IDENTITY_INSERT newtable ON
    INSERT INTO newtable (<column list>) SELECT <column list> FROM
    olddb.dbo.oldtable
    SET IDENTITY _INSERT newtable OFF

    HTH

    "MyaTiX" <com> wrote in message
    news:0dcd01c3623c$a4557690$gbl... 


    Amy Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. How to: Table transfer from MS Access to MS SQL 05server
    By gshuman in forum Coldfusion Database Access
    Replies: 5
    Last Post: September 19th, 09:59 PM
  3. Replies: 4
    Last Post: October 27th, 03:01 PM
  4. Data transfer
    By Russ in forum ASP.NET Web Services
    Replies: 4
    Last Post: June 2nd, 09:53 PM
  5. Replies: 1
    Last Post: July 15th, 06:50 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139