Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Replication on AX database
1 view
Skip to first unread message
Michaël Durand
Sep 17, 2009, 9:28:03 AM9/17/09
to
Hi all,
I am wondering if configuring SQL Server publishers on a AX SQL Server
database is a supported scenario.
I am wondering if configuring SQL Server publishers on a AX SQL Server
database is a supported scenario.
Has any of you already configured a transactional publication (or even a
merge replication) on a SQL Server used by AX ?
Do you have any recommandation in mind (or "Do/Don't" suggestions) ? For
example, I am wondering what could happen if we configure a transactional
publication on 3 columns of a AX table, and if we add a new column to this
table through AX : regarding the synchronizations done up to there, are they
broken ? Or is this completely transparent to the subscribers ?
Thanks for your help,
Regards,
Mic.
sams
Oct 25, 2009, 9:49:01 PM10/25/09
to
I'm no SQL Admin so my knowledge is very limited but we are running
replication here.
In order to synch the table with the new field you would have to delete the
subscription and publication because the synch is trying to change the schema
and that can't happen while there is a publication on the DB.
replication here.
In order to synch the table with the new field you would have to delete the
subscription and publication because the synch is trying to change the schema
and that can't happen while there is a publication on the DB.
0 new messages