Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Data Migration from different Databases

Author  Topic 

nzmhtpgl
Starting Member

1 Post

Posted - 2011-08-26 : 02:55:26
Hi,

I have an OracleDb. I convert it to MsSQlDB called MSDb.And also i have a different Db called MSDb2.MSDB2 has no data.I want to migrate datas from MSDb to MSDb2.But this two databases are not the same with each other.they include different tables,different column names.
Is there anyway to bind one or more tables or columns to other Db's tables columns to transport data?

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-09-09 : 15:07:05
you mean column mapping under DTS?

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -