Replicate tables from one SQL database to another

Walter2

Though not beeing a navision programmer, i've been involved in a conversion project where navision fin version 2.6 is being used as the database. However our company consist out of two locations (2 countries) with two seperate databases. Because of the tight intergration of these companies data needs to be replicated from one database to another. Our solution centre has developed a mechnism to accomplish that task via transmitting ascii files from one site to another via a decicated WAN.

However I'm concerned about the stablity of this solution. Fortunately our management already has decided that for this purpose the database should be upsized to a SQL server database.

Within SQL server it would be much easier to force replication of tables from one site to another in a safe manner. However I'm not familiar with the implementation of the navision database within SQL server. Has anyone have any experience or insights in accomplishing this particular tasks. Are there any pitfalls in this process ??

Walter,

mfabian

The topic of upgrading a FIN-DB to SQL Server has been discussed very often in this forum when Fin 2.60 was released around March this year.

Personally I don't have experience with Navision SQL but from what I recall (and what has been officially published by Navision) this is a very easy task:

1) Make a backup of the Fin-DB
2) Create SQL Server DB
3) Restore the Backup into the SQL DB

Marcus

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

Walter2

Unfortunately this is not what I meant. Because we have two companies (One in Belgium and one in the netherlands), we want to have two SQL databases replicating data to eachother. This means that if a customer is added in Belgium, shortly after that it should be available in the Netherlands too. Though I know this is possible via loose coupled replication, I don't know if there are any gotcha's in the Navision version of the SQL database and like to know if someone already has some experience in this field.

Regards walter,

jtlanejr

When I took the NF-SQL 2.5 class over the summer, replication was not available. I have not heard that this was changed for 2.6. I doubt that was.

Jack

brucem

I have tried setting up a basic replication system using sql 7 and the cronus demo.

replication services just hate the table name / structures where there are "illegal" characters in them thing such as periods slashses, and %

Has Navision solved this for the next release ???

Bruce

Bangkok

Try http://www.kloster-import.dk/

They have a very goor replicator.

Greetings
Walter