Hi, i have a question about sql server replication and Nav.
Scenario : replicating a nav database for reporting
I have the master database server in Italy, another server in another state; i need (in this case with a shapshot replication) transfer structure and data from my server to other server.
My problem is that the internet connection is very slow and sometimes is disconnected (for man reasons the connection is lost). The Sql replica try to resend structure and data but in target database i found many errors execution; i need the target database only for reporting.
I used only snapshot replication becasue with NAV a can't use a merge or transactional replication (sql add dedicated colunms for management ).
Anyone have a suggestion? it's possible syncronize the databases with other solutions?
Thanks for support.
How big is the database? How frequently do you need to refresh the reporting database?