March 18, 2009 at 8:28 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy