Now I am sure I am treading in territory that many say not to tread, but I am curious if anyone has done Database replication with the BEDB Database?
I know one challenge would be getting the SQL instance updated to standard and not using Express.
I guess this would be easy enough if the BEDB was installed on an SQL instance, but wouldn't tamper with this if you're trying to replicate SQL Express to SQL. This is more a question to ask in the Microsoft forums.
Thanks for the replies thus far.
Well It will be mostly for reporting and monitoring. I have built some sql queries and powershell scripts which will do certain scenario checks and report on them. Its just easier to have a central location to get the info from rather than pulling from different servers all over the place.
So its not for any sort of control of BE, but rather for reading off.
Im busy also playing with CASO to see if it will do things I want rather than setting up a mirror.
Just an update:
I have looked at what information you can centralise off CASO and I can typically get all the Data I want for Reporting. Unfortunately there is a possibility that I cannot use CASO because of workgroups etc, so I am still looking into SQL Replication to centralise the information I want.
I'll post my findings