>> 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.
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 ...
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!