[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference amcucs::ms-sqlsvr

Title:Microsoft SQL Server Support
Notice:Please Registar, Note #11
Moderator:AMCUCS::BETTS
Created:Tue Aug 23 1994
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:382
Total number of notes:1233

333.0. ""SQLanywhere" and SQL-Server on same system?" by OTOOA::JPOND () Thu Jan 30 1997 15:00

    Hi,
    I just visited a customer today that wants to (for migration purposes
    only) have both SQL Server and "SQLanywhere" running on the same NT box
    at the same time, each with separate, unrelated applications. 
    Apparently, SQLanywhere is the former Sybase/Watcom product.
    
    Will have both of these running on the same box possible?
    
    Secondly, longer term they want to run a number of applications on a
    single box with SQL Server. I don't know much about SQL Server, but are
    there issues related to running multiple database instances on a single
    box like this?
    
    Thanks in advance for any pointers,
    Jim
T.RTitleUserPersonal
Name		DateLines
333.1CSC32::HOEPNERA closed mouth gathers no feetThu Jan 30 1997 19:4311
    
    
    I am not familiar with SQLanywhere so I cannot answer that question. 
    
    You can many SQL Server databases on the same machine.  They must
    be uniquely named.  They will use the same master database provided
    by the SQL Server installation. 
    
    SQL Server does not have the same concept of 'instance' as does 
    Oracle.
333.2OTOOA::JPONDFri Jan 31 1997 08:3912
    The customer told me that "SQLanywhere" is the former Watcom product
    from Sybase that is based upon the Sybase SQL Server code. I don't have
    any point of reference, so I'm not sure what this actually means.
    
    But hypothetically, could Microsoft SQL Server and say, Sybase SQL
    Server for Windows NT (is there even such a thing?), both co-exist on
    the same NT server? How about co-existence of Oracle and SQL Server on
    a single Windows NT server, does that work?
    
    Thanks in advance,
    Jim
333.3*Should* work....TBC001::DROVERHEDGEHOGFri Jan 31 1997 13:5115
    There is such a thing as Sybase SQL Server System 11 for WIndown NT. I
    do not see why the database systems could not co-exist. *BUT* I would
    doublecheck that with Watcom/Sybase and MS to make sure. One
    potentital issue I could think of would be DB-LIB revision issues if
    they co-exist and things along those lines. But I don't see why it
    wouldn't work *if* the box has the muscle for it. Just make sure the
    memory segment is allocated correctly so that MS SQL Server leaves room
    for another process.
    
    There may be other issues I may not be aware of or it just may work
    first time no problemo. I wish I could be more help but I have never
    attempted it. Most servers I configure tend to be dedicated.
    
    James
333.4CSC32::HOEPNERA closed mouth gathers no feetFri Jan 31 1997 19:066
    
    I would be very concerned if different companies products walked all 
    over the installation of another companies products.  I suspect there 
    is considerable effort to keep that from happening.  ;-}