Sync tables between 2 databases
Baan: iBaanERP 5.0c
DB: SQL Server 2008 R2
OS: Windows 2008
Hi, we are having a production system and on a separate Server our Testsystem. Both are having the same OS and the same Version of SQL Database.
To refresh our Testsystem from time to time I was thinking about to synchronize some tables we need from the production system to the Testsystem.
I don't want to copy the whole database because then I have to make a lot of adjustments on the Testsystem again.
Any idea how this could work?