synchronise table from 2 databases

[TomasCrossroads]

Hello,
I have a problem updating data in sql server database. Here's the situation. There's an (old) asp application running on a database 'intranet'. We made a new application with a new database 'intranet2'. Intranet2 contains all tables from database intranet + a lot of new tables. Now the development of the new application is finished we like to start using the new application, but the tables in the new database 'intranet2' that were also in the old database 'intranet' should be updated first. There has been added new data in the old database during the development of the new application. Is there an easy way to do this? I could copy the tables, but the problem is that in that case I will have to redesign all tables (adding relationships etc.).
Any suggestions please?
Greetings

 

[SQLSister]

Use DTS to transfer the data to the new structure. YOu can also use the Execute SQL task within the DTS package to make other adjustments you need to the data such as adding the information for additional fields or separating a field into two or more new fields.