June 2, 2003 at 10:44 pm
We have development servers/wks which are disconnected from the production server.
Time to time, we have to transfer, some of tables(usually used in enumerating for eg Y101=Real Estate Firm etc.) to production server. I want to know what is the best way of doing this. We need a policy on this. Please help.
TIA,
Parag
June 5, 2003 at 8:00 am
This was removed by the editor as SPAM
June 11, 2003 at 8:14 am
I suggest that you create a DTS package which moves data of interest from disconnected servers to a statging area where you can clean and validate the data before you load into the production server.
A sepeerate DTS package can be called to load validated data into the production server.
points to consider
a. you can create a DTS package on each of the disconnected servers . This package will only pump data from one server to the staging area. This option is good if you don't want your production server to be doing the data load operation.
b. Create one DTS package on the production server. This will pull data from all disconnected servers into the staging area. This option is easier to maintain.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply