April 16, 2006 at 9:38 am
Hi
I need URGENT help bringing across some specific data that is currently residing on a separate SQL database on the local instance of our TEST server to another SQL database on our LIVE server. I intend to do a SELECT query on the SOURCE database on the TEST server and bring the query results across to the TARGET database which is on the LIVE server. We are on SQL 2000.
I believe that the Import/Export option in DTS is the best way but am weary of which options to select as past experiences have not been very positive with respect to constraints, indexes, triggers etc dropping off.
Is there a step by step guide that I can follow that is fool proof.
Are there any prerequisites that have to be done eg linked servers??
Can anyone please help ??
April 17, 2006 at 11:07 pm
Can anyone please assist??
April 18, 2006 at 10:53 am
I don't have a step-by-step guide, but I suggest http://www.sqldts.com/ and the book "Professional SQL Server 2000 DTS" by WROX as excellent reference material.
This sounds like a pretty basic DTS process where you could either use the import/export wizard or create a DTS package. Is there a specific problem that you're trying to avoid with DTS?
Greg
Greg
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply