<div>
Hi <br />
<br />
Assuming you are using sybase replication server . This can be handled in the replication defintion<br />
<br />
When you create the replication definition in the source database you can define the replicate table name and replicate column name if the names are different<br />
<br />
Please refer<br />
<br />
<a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32410_1501/html/refman/X81836.htm" rel="ugc">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32410_1501/html/refman/X81836.htm</a><br />
<br />
the option is <br />
<br />
as replicate_column_name<br />
&nbsp; &nbsp; Specifies a column name in a replicate table into which data from the primary column will be copied. Use this clause when the source and destination columns have different names.<br />
<br />
<br />
There are more ways to handle this using function strings if you need some manipulation of data as well<br />
<br />
HTH<br />
<br />
Maneksh<br />
<br />

</div>


Hi

Assuming you are using sybase replication server . This can be handled in the replication defintion

When you create the replication definition in the source database you can define the replicate table name and replicate column name if the names are different

Please refer

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32410_1501/html/refman/X81836.htm [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32410_1501/html/refman/X81836.htm]

the option is

as replicate_column_name
    Specifies a column name in a replicate table into which data from the primary column will be copied. Use this clause when the source and destination columns have different names.


There are more ways to handle this using function strings if you need some manipulation of data as well

HTH

Maneksh



<div>
Sorry, I meant create replicaiton definition in the rep server ...<br />
<br />
Thanks<br />
Maneksh
</div>


Sorry, I meant create replicaiton definition in the rep server ...

Thanks
Maneksh

<div>
You can do this creating replication definition.<br />
<br />
Inside the REPDEF, you can say:<br />
<br />
(PRIMARY) tabelaX.ColumnX will replicated into (REPLICATED) tabelaY.ColumnY<br />
<br />
This way, you can solve your problem.
</div>


You can do this creating replication definition.

Inside the REPDEF, you can say:

(PRIMARY) tabelaX.ColumnX will replicated into (REPLICATED) tabelaY.ColumnY

This way, you can solve your problem.

<div>
<div class="content wysiwyg-content">
We are creating a replication, source and destination database structure is same but some of table names and column names are different. How to handle this situation.<br />
thanks,<br />
Ravi
</div>
</div>


We are creating a replication, source and destination database structure is same but some of table names and column names are different. How to handle this situation.
thanks,
Ravi

Replication

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.