I need to transfer data from one MS SQL 2005 Database to another MS SQL 2005 database. Both Databases have 12 tables and there are a total of 231 fields.
There is a one-to-one correlation between the fields of the old database tables and the fields of the new database but the data has been rearranged and the new database has a different structure (all fields are the same data types though). The issue is simply one of reading the data out of one database server and then writing it into the new database.
Both servers are on the same network.
You can use whatever language you want and it can be either a Web Based or Windows Based application.
Thanks in advance!