SEO

#1 (**permalink**) 04-20-2008, 12:11 PM

Hello, I have the view from a table that keeps incrementing with new
values, I have no control of this database, but I need to retrieve the
new values to insert it on my table (sql server) and send some
parameters of the database to another application, I'm using C# to get
access to both databases, so does anybody know of an efficient way to
retrieve only the new values of the dtabase?

Thanks a lot

Luis Saavedra

#2 (**permalink**) 04-20-2008, 12:11 PM

On 2 Oct 2006 15:58:23 -0700, "luissol" <luissol@gmail.com> wrote:

>Hello, I have the view from a table that keeps incrementing with new
>values, I have no control of this database, but I need to retrieve the
>new values to insert it on my table (sql server) and send some
>parameters of the database to another application, I'm using C# to get
>access to both databases, so does anybody know of an efficient way to
>retrieve only the new values of the dtabase?
>

Is it possible to put an insert trigger on this table?

JWC

#3 (**permalink**) 04-20-2008, 12:12 PM

No, because I have no control over the Informix database, they have an
ID for each registry, the problem is that not all the times it is
sequential, for example they have

1
2
4
5
6
3 (not in order)
7
8
10
9 (not in order)

what I have considered is using a counter in a table of my database,
then use a count of all the registers of the informix table and get a
top (of the difference between these two tables), the problem is that
if in the lapse between the count and the selection of the registers
they insert something in the table of informix, I will be missing some
values, any ideas to solve this or use another solution...

Thanks

Luis Saavedra

John Carlson wrote:
> On 2 Oct 2006 15:58:23 -0700, "luissol" <luissol@gmail.com> wrote:
>
> >Hello, I have the view from a table that keeps incrementing with new
> >values, I have no control of this database, but I need to retrieve the
> >new values to insert it on my table (sql server) and send some
> >parameters of the database to another application, I'm using C# to get
> >access to both databases, so does anybody know of an efficient way to
> >retrieve only the new values of the dtabase?
> >
>
> Is it possible to put an insert trigger on this table?
>
> JWC

#4 (**permalink**) 04-20-2008, 12:12 PM

Could you possibly use sqlserver as your driver instead.
check into DTS (data transformation services) if you are not on sqlserver2005,
otherwise on ss2005 you can look into SSIS (sqlserver integration services...
replace DTS).

you may have to experiment with the DTS/SSIS process flow tasks, but i bet
you could get it to work.
unless that is of course, you are not running a Sqlserver version that has
these capabilities or like your informix DB, you don't have much control on
your Sqlserver side either.

Norma Jean

luissol wrote:
>Hello, I have the view from a table that keeps incrementing with new
>values, I have no control of this database, but I need to retrieve the
>new values to insert it on my table (sql server) and send some
>parameters of the database to another application, I'm using C# to get
>access to both databases, so does anybody know of an efficient way to
>retrieve only the new values of the dtabase?
>
>Thanks a lot
>
>Luis Saavedra

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....ormix/200610/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Retrieve new values of a database