October 4, 2006 at 11:36 am
I am in the process of creating a data warehouse (SS 2005)that updates a large chunk of data nightly from another SQL database (ss 2000) on a different server. The ss2000 box is being used by a 3rd party application.
Two Questions:
1 - What would be best method of pulling data from the ss2000 box?
Note: the data would be pulled nightly and would include all data for active projects.
Link the databases/dts package/?
2 - What would be the suggested method for setting up the access account from the SS2005 to SS2000?
all help appreciated
Daryl
October 5, 2006 at 7:57 am
depending on the amount of data you'd expect ....
- you could setup replication to your needs and sync nightly
- you could use the tablediff.exe (check books online).
this ms-util generates insert/update/delete-statements
- 3-th party tools (e.g. redgate sqldatacompare, dbghost ...)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 5, 2006 at 12:58 pm
Again dependant on the data volume; we tend to use DTS to flatfile, remote tools (Connect Direct in our case) to move the file and then DTS (or SQLLDR is Oracle) to load.
Because we are moving files between DBMS's, and data volume can be significant, flat-file is our preferred option but it may not be best for you.
HTH
October 6, 2006 at 4:38 am
In this version you want to use Integration Services to haul your data over and into your warehouse.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply