I have a SQL Server Express 2014 named instance containing 3 databases (One for each office). connected to a WinForms application.

Each database is uniquely named after the respective office although containing the exact same tables & table names with different data.

I want to set up transactional replication from the local databases to Azure. Will having the same table names in different databases create a problem when replicating to Azure?

What would be the best workaround for this? The 3 databases cannot be merged into one and renaming the table names create problems when using the Winforms application.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.