Insert, Update data from anothere server which do not have SQL Client

• Jeff-394295

  Grasshopper

  Points: 23

  More actions

  March 18, 2009 at 8:28 am

  #219260

  Hi, here my scenario.

  -Server1 (windows 2003) have SQL Server 2005 with my web application

  -Server2 (windows 2003) have Oracle 9i which have many terabytes of data into it.

  I would like to use a BATCH file on Server2 to insert data into the Server1 MSSQL table.

  On the SQL server i have a stored proc with 5 parameters, (@Data_Month int, @Execute_Date datetime, @Application_ID int, @Checklist_ID int, @Activity_Status nvarchar(50))

  The thing is i cannot install the MS SQL client on the Oracle windows server. Should i use batch file, SQL file, what approache should i go with?

  thank you

• lrosales

  SSCommitted

  Points: 1821

  More actions

  April 10, 2009 at 8:56 am

  #975815

  if you have not solved the problem yet, the most logical option is to link the servers, the use the openrowset or just use the format which I use which is

  Openations -- (Insert, delete, Update)

  servername.database.schema.tablename

  where Logic

  see if this helps.

  thanks

  "We never plan to Fail, We just fail to plan":)