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 |
|
ebhlive
Starting Member
4 Posts |
 Posted - 2009-03-04 : 19:47:43
|
| I'm completely new to SSIS. Hopefully this is a simple question and answer.Can I use SSIS on a SQL 2005 server to export data from a database on a SQL 2000 Server into a database on a SQL 2005 server?I have a server I'm not ready to upgrade yet due to time constraints, but have an immediate need to port data from 2000 to 2005.If the answer is no, any suggestions other than an upgrade (which will happen in the future, just not in the next month)? I could DTS the data out into text files and then use SSIS to read the text files into the 2005 box, but not sure if that's the best way.Thanks!EBH |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-04 : 19:53:13
|
| how much data do you want in your new 2005 sql server a subset or the whole thing. can't you do backup and restore. Then when ready to move it's all there IMHO2 cents |
 |
|
|
ebhlive
Starting Member
4 Posts |
Posted - 2009-03-04 : 21:20:22
|
| We need to move the data on a nightly basis as opposed to just once. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-05 : 09:55:22
|
| we did this once for our test server where we did a nightly backup from production server, copy backup file to test server then a restore. you can automate this. first part basic back up, then a SSIS package on your 2005 server that does the RESTORE DATABASE command. |
|
|
|
|
|
|
Using SSIS to get data from SQL 2000