Hi, I have a scenario where I have configured SQL Server local on a tablet and save some data temporarily to that local db. As soon as there is internet available the data saved offline gets synchronized to the main SQL Server. Can I use the subscriber and publisher concept here i.e merge replication?
Do you need data back to your local? You can setup but not schedule transactional replication if all it needs is to go from tablet to main db. I do not recommend any data to saved on local instances for work stations. If you are public company, that’s can easily fail audit and can get company into huge trouble if your tablet is compromised.
@@TechBrothersIT My requirement is saving the data ultimately to main SQL Server from the local SQL Server Express. I thought of implementing merge replication. What are your thoughts on this? Please let me know your thoughts. Thanks in advance.
Greetings. To that publication, can I add as many subscribers as I want? I have 8 servers and I have tried to replicate from a Master, but when I add a new subscriber and start synchronizing, after a few minutes it tells me that "The merge process could not replicate one or more INSERT statements" that I checked in the SQLProfile and That solves the problem. What could be happening? Will I have found something wrong? I look for the processes and delete the ones that run the synchronization and then restart the SQL Server agent and start the process again, but after a few minutes the same problem happens. Any idea what I could have done wrong? Beforehand thank you very much!
in the last step i deleted the merge replication to test it out .. then opened the file which i had saved during publishing. that went through but in the secondary server. the subscription file didn't come . so i tried running the new file for subscription in the secondary server. it said subscription already exists. ??
I want to update and migrate database from SQL Server 2014 to SQL Server 2019 so that if there is any failure at SQL Server 2019 I will come back at SQL Server 2014 and get all the transactions back at SQL Server 2014 which held at SQL Server 2019. Although I thought about merge replication. But want to know if the SQL Server 2019 fails so in this case will merge replications process occur. Will I get data of SQL Server 2019 in SQL Server 2014. Please suggest a possible solution.
Sir, first, replication isn’t a rollback solution - it is highly object based, you can’t possibly add all articles in replication. Are you upgrading on new servers with 2019? It does sound like that .... you need to migrate and coordinate a cutover activity just before go live - if something goes wrong, you can shutdown new servers and point back on 14.
+Jordan Mendoza check the filter when you click on articles and select all objects - also make sure the table you want to replicate has primary key. Thanks,
Hi, i did merge replication one way from Publisher to Sybscriber.But when i inserta record, a new rowguid is generated in the subscriber.Why is it so?
Hi,
I have a scenario where I have configured SQL Server local on a tablet and save some data temporarily to that local db. As soon as there is internet available the data saved offline gets synchronized to the main SQL Server. Can I use the subscriber and publisher concept here i.e merge replication?
Do you need data back to your local? You can setup but not schedule transactional replication if all it needs is to go from tablet to main db.
I do not recommend any data to saved on local instances for work stations. If you are public company, that’s can easily fail audit and can get company into huge trouble if your tablet is compromised.
@@TechBrothersIT My requirement is saving the data ultimately to main SQL Server from the local SQL Server Express. I thought of implementing merge replication. What are your thoughts on this? Please let me know your thoughts. Thanks in advance.
Greetings.
To that publication, can I add as many subscribers as I want?
I have 8 servers and I have tried to replicate from a Master, but when I add a new subscriber and start synchronizing, after a few minutes it tells me that "The merge process could not replicate one or more INSERT statements" that I checked in the SQLProfile and That solves the problem.
What could be happening? Will I have found something wrong?
I look for the processes and delete the ones that run the synchronization and then restart the SQL Server agent and start the process again, but after a few minutes the same problem happens.
Any idea what I could have done wrong?
Beforehand thank you very much!
in the last step i deleted the merge replication to test it out .. then opened the file which i had saved during publishing. that went through
but in the secondary server. the subscription file didn't come .
so i tried running the new file for subscription in the secondary server. it said subscription already exists. ??
did you merge the files for publication and subscritipon
It's working fine while I am using only tables but with stored procedure I am getting sp_hexadecimal error.. how to fix it
can client(subscriber) database sync with each other in absence of server(publisher)
I want to update and migrate database from SQL Server 2014 to SQL Server 2019 so that if there is any failure at SQL Server 2019 I will come back at SQL Server 2014 and get all the transactions back at SQL Server 2014 which held at SQL Server 2019.
Although I thought about merge replication. But want to know if the SQL Server 2019 fails so in this case will merge replications process occur. Will I get data of SQL Server 2019 in SQL Server 2014.
Please suggest a possible solution.
Sir, first, replication isn’t a rollback solution - it is highly object based, you can’t possibly add all articles in replication. Are you upgrading on new servers with 2019? It does sound like that .... you need to migrate and coordinate a cutover activity just before go live - if something goes wrong, you can shutdown new servers and point back on 14.
@@TechBrothersIT which replication is best for transferring 10 TB of data ,Merge or Transactional and Why?
Any help guys? The table from sql mirror server doesn't show up the table that must be replicated
+Jordan Mendoza check the filter when you click on articles and select all objects - also make sure the table you want to replicate has primary key.
Thanks,
TechBrothersIT.. thanks for the reply
Please show conflict resolution also
thnks alot
well done!
parvanoff1 - Thank You !!!