migration or transfer data

[never]

Hello,
I would like to migration data from one database with some data structure to the other database with completly diferent structure...both are created already

for example
1. old table with this structure: name, surname, adress,hobby
2. the new one have this structure: surname, payadress,

please give me some sugestion how can i do it

thanks a lot
N.

 

[foxdev]

You can use SELECT with the INTO clause, such as:

[tt]select surname, address as payaddress
into db2.dbo.Table2
from db1.dbo.Table1 [/tt]
Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Sina]

You may want to try SQLPorter from realsoftstudio.com

save your time

you can see them at

http://www.realsoftstudio.com