VB 6 code for pulling records .

[sunnydreams]

I have the records in a database( Table 1) .Now I want to write code, to pull those data from Table1 to different database(Table 2) which is on a different Server and should run that (Table2) code every month.ie.it has to be rerun.

Can anyone of u Pls help me with this code. I use Microsoft Sql server 2000.
If u need any more details let me know.
Thx in advance.

 

[fredericofonseca]

Use a DTS package. Schedulle this on the server to run when you need it.


IF you go to EA you should be able to do it yourself with the help of books online, or even without it.

No code required unless you wish to do a specific SELECT.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[sunnydreams]

Thx for the update,
My first database(Table1) is in the QA server and the Second one (Table2)in the Development Server.I want to pull teh records from QA to development so that we can rerun that once ina month.

Can u Pls explain abt the DTS package u have mentioned..Will that solve this prob? I am very new to the programming field.Can u Pls help me.

Thx again

 

[fredericofonseca]

Ask you DBA or senior programmers for help. they should know.

But this is done through the Enterprise manager interface.

go there, select the Data Transformation Services, select to create a new package, and then add two connections and a data transform task, or select a copy SQL Server objects task.

as I said you should be able to get this going with the help of the online manuals.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com