Move ODB from Mac to Windows 2012 R2

[Stephen Baugh]

Thanks, Reg 

I must say ODB is pretty cool, and other than speed (at times) and record locking occasionally it has served us very well. I can’t wait for the pure scale and speed of a full SQL implementation though.

I appreciate the guidance thank you. 

Cheers
Stephen


On 16/12/16, 12:01 PM, "omnisdev-en on behalf of Reg Paling" <omnisdev-en-bounces at lists.omnis-dev.com on behalf of reg.paling at lokanet.com> wrote:

    Hi Stephen,
    
    It is totally simple.  Just move the datafiles to the Windows 2012 
    server, install the latest ODB for windows and configure it to point to 
    the datafiles, and point the clients to the new IP address.  Everything 
    else will work exactly as before.
    
    The only thing I am not completely sure of, is whether windows will 
    handle your number of segments and number of users better or worse than 
    the Mac.  I suspect it will probably be better, but others may have 
    direct experience of that sort of scale.
    
    Cheers,
    Reg
    (Reluctant defender and advocate of ODB!  ;-)
    
    
    
    On 16/12/16 9:43 am, Stephen Baugh wrote:
    > Hi
    >
    > We currently have an approx. 3.5GB 20 Segment ODB database (Studio 6.1.2) hosted on a Mac Server running Osx 10.10.5. We would like to move this to Windows 2012 R2, but the documentation is a bit confusing.
    >
    > It says ODB is for sharing files from Mac, but then mentions Linux and Windows 2000/XP/7, so first question is can this be moved to 2012 or is the something else we should be using to share the DB. We are moving to SQL but still have significant data in the native data file.
    >
    > Second question is, is the migration safe? We should hate to risk the data integrity by moving it to Windows, if for example the data files were not completely compatible with the OS. Has anyone else made this move?
    >
    > Thanks
    > Stephen
    >
    > PS This is a temporary move while until we finally move completely to MySQL in about 4mths time.
    >
    > _____________________________________________________________
    > Manage your list subscriptions at http://lists.omnis-dev.com
    
    
    _____________________________________________________________
    Manage your list subscriptions at http://lists.omnis-dev.com