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.
| Author |
Topic |
|
klilley
Starting Member
1 Post |
 Posted - 2008-12-22 : 11:34:08
|
| I need to do a one-time transfer of data from multiple tables in an old version of a database to a newer version on the same network, both are SQL Server 2005 databases, but on different servers. I am not transferring all of the data, but only the subset that exists in the old database but not in the new. The schemas for the tables involved in the transfer are identical. My first question is whether using SSIS is the best way to accomplish this, or if there is an easier way to export rows from some tables and import them into identical tables in another database?If SSIS is the best way, then my next question is do I need to have SSBIS installed on a machine on that network in order to develop or run the package?Any help would be greatly appreciated. This is one of those tasks that kind of landed on me since we don't have a regular DBA right now. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-22 : 19:53:45
|
| Yes you can use SSIS to achieve it. |
 |
|
|
|
|
|
Is SSIS Export Import the best way to do this?