Post reply

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

  • 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

  • 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":)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply