| Author |
FROM SQL TO ORACLE
|
|
| Nazeedah 2006-04-27, 7:25 am |
| Hello
I am using Biztalk 2006. I have retrieve records from a sql database and
store it in an oracle database by using Biztalk.and it retrieve and insert
the records successfully.
But it has to check the records whether if exist then do not insert else
insert the records in the oracle database.
Can anyone help me of how to continue with it.i have not use any orchestra
to do the above one.
If you need any additional info, please do ask..
Regards
| |
| Lucas R. Vogel 2006-04-27, 7:25 am |
| What you are trying to do is something that could be done more efficiently
with the use of database logic. I would suggest creating a stored procedure
that verifies the existence of the record and performs the insert based on
your criteria.
Hope this helps!
Lucas
--
===========
Lucas R. Vogel
"Nazeedah" wrote:
> Hello
> I am using Biztalk 2006. I have retrieve records from a sql database and
> store it in an oracle database by using Biztalk.and it retrieve and insert
> the records successfully.
> But it has to check the records whether if exist then do not insert else
> insert the records in the oracle database.
> Can anyone help me of how to continue with it.i have not use any orchestra
> to do the above one.
> If you need any additional info, please do ask..
>
> Regards
| |
| Nazeedah 2006-04-27, 7:25 am |
| Hello
Thx a lot for your reply.
Can you explain me in more details what you mean by database logic and
stored procedure. Where should i do the stored procedure?
Should i do it when i write the sql statement?
About the stored Procedure how can i check the existance of records from two
different database..
Regards
| |
| Matt Milner 2006-04-27, 7:25 am |
| I'd use DTS for this instead of BizTalk. It will give you more control to
do the database steps you want, and is really geared toward moving data like
this. BizTalk was not built to solve this problem, but many people end up
using it this way (mistakenly in my opinion).
Matt
"Nazeedah" <Nazeedah@discussions.microsoft.com> wrote in message
news:2461A146-AFE6-4AFD-815E-EEB87A50C070@microsoft.com...
> Hello
> I am using Biztalk 2006. I have retrieve records from a sql database and
> store it in an oracle database by using Biztalk.and it retrieve and insert
> the records successfully.
> But it has to check the records whether if exist then do not insert else
> insert the records in the oracle database.
> Can anyone help me of how to continue with it.i have not use any orchestra
> to do the above one.
> If you need any additional info, please do ask..
>
> Regards
| |
| Nazeedah 2006-04-27, 7:25 am |
| Hello,
we are using DTS to do this tasks but we would like to swtch it to Biztalk
as we are having some conflicts with DTS such as sometime there is
duplication or missin data. we are using Biztalk so as in the long term we
could add more functionalities.
well this is our aim by using Biztalk.
so how could i solve my pb in Biztalk taht is could you please give me some
more details about the stored procedure and the database logic.do you mean
create a stored procedure in oracle ? or create it in SQL?
After the creation of the stored procedure, how should i go forward with it??
Thx a lot
|
|
|
|