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 |
|
epaisley
Starting Member
4 Posts |
 Posted - 2007-09-19 : 10:39:57
|
| We are internally upgrading all of our SQL boxes to SQL Server 2005. Unfortunately our web production SQL box is hosted externally at a hosting company and it will be staying as a SQL server 2000 box. Can the new ssis wizards/functionality update tables on a sql 2000 box or a better question what would be the best way to update data (not necessarily copy whole tables) from a 2005 db to a 2000 db? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 11:16:46
|
How do you "reach" the SQL box hosted externally?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
epaisley
Starting Member
4 Posts |
Posted - 2007-09-19 : 11:41:30
|
| We connect through Enterprise Manager and right DTS packages to move data. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-19 : 11:49:03
|
| Have you tried Replication? We had a 2000 box and replicated to it from 2005 server as a backup, for almost a month before we pulled the 2000 box off.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-19 : 11:51:19
|
| to answer your first question, SSIS can work with data in SQL 2000 without any problem.I am concerned with the answer you gave to Peter's question though. Do you connect directly to the hosted database across the internet or via private network? Do you VPN into the network?-ec |
|
|
|
|
|
|
Going from 2000 - 2005 and back