Re: ER between two databases in the same instance
If the user was wanting a real-time copy that could be modified without affecting the source then synoyms or views would cause issues. Although I guess modifying the target could pose update conflicts so even that may not be a great idea. --- Dirk Gunsthvvel <dirk@guncon.de> wrote: > Hi, > > in this very special case is there anything wrong > with > creating a synonym for the table in the other > database > (or a view) ? > > What would be the disadvantage? > > Cheers, > Dirk > > -- > -- Dirk Gunsthoevel IT Systemanalyse phone: +49 > (0)251 28446-0 > -- Hammer Str. 13 fax: +49 > (0)251 28446-55 > -- D-48153 Muenster > http://www.GunCon.de/ > -- "Toto, I don't think we're in Kansas > anymore..." > > > "DL Redden" <redden96@yahoo.com> schrieb im > Newsbeitrag > news:1126222678.d5a1ec96fcc918ab5830491a9bd1bde7@teranews... > > > > Seems to me that it should be something that is > > available. I'm sure that there is a good reason > why it > > is not but I would have assumed that it could be > done > > if I did not no better. If available I'm sure that > > lots of folks would find a user for it although I > > cannot say that I, presonally, have one right now. > > > > --- Madison Pruet <mpruet@comcast.net> wrote: > > > > > Question for the group as a whole... How > important > > > is this functionality? > > > > > > "cristizaharioiu" <cristizaharioiu@gmail.com> > wrote > > > in message > > > > > > news:1125990751.160483.46740@g14g2000cwa.googlegroups.com... > > > > Hello, > > > > > > > > Can I define a replicate for a table between > two > > > databases in the same > > > > instance (the same group) ? > > > > > > > > Here is the replicate : > > > > > > > > cdr define repl -C ignore --scope=transaction > > > --immed --ats --ris > > > > r_tabela_test "P > > > bd_test_1@g_scot79:informix.tabela_test" > "select * > > > > from tabela_test " "R > > > bd_test_2@g_scot79:informix.tabela_test" > > > > "select * from tabela_test" > > > > > > > > I tried to define it and I got next error : > > > command failed -- duplicate > > > > server or replicate (53) > > > > participant > bd_sco79@g_scot79:informix.tabela_test > > > 'select * from > > > > tabela_test '. > > > > > > > > The replicate is not duplicate only server > could > > > be. > > > > > > > > The medium is IDS 10 & Suse Sles 9. > > sending to informix-list sending to informix-list