Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Archiving & Multisite

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
20%
Total votes: 35

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th February 2002, 21:31
sbdmark's Avatar
sbdmark sbdmark is offline
Junior Member
 
Join Date: Feb 2002
Location: Kansas City
Posts: 6
sbdmark is on a distinguished road
Baan: 5.0c - DB: MS SQL Server - OS: NT, 2000
Exchanging data in Baan

I have a single server with two financial companies setup under multisite in Baan 5.0c, in which they share quite a few tables. We are looking at splitting these up because of unreliable WAN connections for one side. The new scarnario requires that there be a one way data exchange on a monthly basis to the same company setup on a second server. In other words, one server now becomes two (app & database together). One company on one side and two on the other. The server with two companies is a local financial company and the second financial company is to be updated monthly.

What is the best way to accomplish a one way data exchange ?

Can SQL server replication be used and are there any specific issues replicating at the database level?
__________________
MDB

Last edited by sbdmark : 21st February 2002 at 18:13.
Reply With Quote
  #2  
Old 6th March 2002, 19:04
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
The official Baan tool to move data about is Exchange, and it's much enhanced for Multisite in Baan V.

You can set up a relationship, including IP Addresses, and Baan will FTP exported data to the Import Directory on the waiting server, ready for "Regular Import". You can set the import up as a job for full automation, or run at your designation. There is some handshaking - ie, you get a confirmation in the sending company if the file has been accepted for import on the receiving end.

Any number of sql scripts will accomplish the same, but Baan will generate the table structures for you, and you can use definition files instead of hard layouts, incase the table definitions change.

A great document for all of this is from Baan:

Document number U7137A US

Kind of hard to find, but out there on the support site. It's not registred very well, it's called Exchange User Documentation, a word document attached to an email they have posted... Here's the path to find:

ftp://ftp.baan.com/public/dumps/Sol-150963/documents
Reply With Quote
Sponsored Links
  #3  
Old 6th March 2002, 23:03
sbdmark's Avatar
sbdmark sbdmark is offline
Junior Member
 
Join Date: Feb 2002
Location: Kansas City
Posts: 6
sbdmark is on a distinguished road
Baan: 5.0c - DB: MS SQL Server - OS: NT, 2000
Thanks for the info. I read the documentation and am concerned about keeping the business logic in sych between my servers for shared tables. If I import via the DAL, will this take care of the business logic?
__________________
MDB
Reply With Quote
  #4  
Old 6th March 2002, 23:10
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
Yes, that's the idea anyway. It will call all of the DAL table validations, and the field checks if you check that as well. We have seen this done in the debugger, so I know it works. As long as the DAL has all the necessary logic anyway...I would recommend some testing as well.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Migration from Baan IV c4 SP4/WinNt4.0 to Baan IV c4 SP9/Windows2000 Server Gigaman Operating Systems & Databases 8 26th July 2004 14:19
exchanging data/changing data URGENT shrikantc Tools Administration & Installation 7 1st May 2003 22:40
BaaN Data Backup (SQL) vishbaan Tools Administration & Installation 1 25th September 2001 01:15


All times are GMT +2. The time now is 18:27.


©2001-2018 - Baanboard.com - Baanforums.com