Copy data from a table to another one has different structure

Posted by Kernel on Stack Overflow See other posts from Stack Overflow or by Kernel
Published on 2010-03-29T05:58:13Z Indexed on 2010/03/29 6:03 UTC
Read the original article Hit count: 136

Filed under:

migrate

I have two tables with different structure:

TableSource: intId(not null), txtSummary, strDetail

TableDesc: guidId(not null), guidFK(not null), Name, Detail

I want to migrate data from two fields of tableSource(txtSummary, strDetail) to two fields of tableDesc(Name, Detail).

For simply,suppose that guidId and guidFK are auto generation.

I'v tried but not success. Could anyone help me?

Related posts about migrate

Is there a rake task for advancing or retreating your schema version by exactly one?

as seen on Stack Overflow - Search for 'Stack Overflow'
Back when migration version numbers were simply incremented as you created migrations, it was easy enough to do: rake migrate VERSION=097 rake migrate VERSION=098 rake migrate VERSION=099 rake migrate VERSION=100 ...but we now have migration numbers that are something like YYYYMMDDtimeofday. Not… >>> More
Migrate Woodstock Components to ADF Faces

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
For woodstock users looking for a complete replacement >>> More
WSS3.0 to SharePoint Foundation 2010 upgrade

as seen on Server Fault - Search for 'Server Fault'
Hi guys, I've got a Windows 2003 x86 server with a small WSS3.0 installation. Now we've bought a new server with Windows Server 2008 x64 and installed SharePoint Foundation 2010 on it. I wish to transfer the few lists and their view from the old WSS3 to SP2010. How should I do this? All the migration… >>> More
BSOD trying to migrate Windows XP from a physical to a virtual machine

as seen on Super User - Search for 'Super User'
I am attempting to migrate a Windows XP Home installation from a physical machine to a virtual machine. The physical machine has two hard disks; the first is 250GB containing the "C:", the second is 1TB containing "D:". I'd like to create a new virtual machine stored on the D:, which is a copy of… >>> More
Backup, Migrate or Clone Failing CentOS 4 (LVM)

as seen on Server Fault - Search for 'Server Fault'
Hello there, I've been running a BlueQuartz CentOS 4 system (Nuonce.net distro) for a few years now and although the hard drive (Deskstar) has always been a bit noisy, on a few recent occasions I've heard it having trouble spinning up. Basically, I want to clone this drive to a similar sized one… >>> More

Developer IT

Copy data from a table to another one has different structure - Developer IT

Copy data from a table to another one has different structure

migrate

Related posts about migrate

Is there a rake task for advancing or retreating your schema version by exactly one?

Migrate Woodstock Components to ADF Faces

WSS3.0 to SharePoint Foundation 2010 upgrade

BSOD trying to migrate Windows XP from a physical to a virtual machine

Backup, Migrate or Clone Failing CentOS 4 (LVM)

Categories cloud