replication - do i need to regenerate

Posts   
 
    
gram
User
Posts: 8
Joined: 05-Jul-2006
# Posted on: 09-Oct-2006 11:32:33   

Hi

i'm going to setup replication on production server, do i need to setup it locally first and regenerate adapter code to add replication id column to tables schema, or it will work nicely without this step?

thanks

Jessynoo avatar
Jessynoo
Support Team
Posts: 296
Joined: 19-Aug-2004
# Posted on: 09-Oct-2006 15:52:15   

Hi, I'm not familiar with replication but I don't think it involves changing the way you address your dbase, so I'd say you don't have to anticipate that with your DAL.

gram
User
Posts: 8
Joined: 05-Jul-2006
# Posted on: 09-Oct-2006 18:45:15   

well replication just adds new column to each replicated table with type uniqueidentifier and default(newid()) for internal usage.

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 10-Oct-2006 02:03:41   

I would think that you do not need to regenerate your code since you would not be accessing these columns. If however you are using views then you may want to double check that any that use the * for the select list are refreshed. I believe the stored procedure to do this is sp_refreshview.

gram
User
Posts: 8
Joined: 05-Jul-2006
# Posted on: 10-Oct-2006 10:52:41   

ok, thank you. I'm not using sp or views, all code is pure llblgen simple_smile