Xref: alice comp.databases:36199 comp.databases.ms-access:274014 comp.databases.ms-sqlserver:37370 comp.databases.oracle.server:48336 From: "Randy Baker" References: Subject: Re: SQL server Vs Oracle Date: Wed, 5 May 1999 14:23:31 -0400 Lines: 29 X-Newsreader: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: <#IL4rRyl#GA.179@cpmsnbbsa02> Newsgroups: comp.databases,comp.databases.ms-access,comp.databases.ms-sqlserver,comp.databases.oracle.server,microsoft.public.sqlserver.server,microsoft.public.vb.database Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!207.46.180.32!cpmsnbbsa04!cpmsnbbsa02 Another angle not mentioned in the other (mostly anti-SQL Server) posts: If you do many joins and are using the INNER JOIN or LEFT OUTER JOIN syntax, then you will have to rewrite any of your Access queries that use these. SQL Server will accept most Access SELECT statement syntax without modification. If you are an MS shop (and it appears that you are based on your question), I would go with SQL Server, if only because all the Oracle stuff will appear totally foreign to what you are used to. SQL Server (particularly 7.0) is *much* easier to set up and administer. Oracle can certainly claim scalability advantages, but these aren't likely to apply to an upsized Access database, nor are they likely to apply to anything running on NT. Randy Ling wrote in message ... >Hi all, >Our project team is looking into upsizing a VB/Access database to either MS >SQL Server/ Oracle on NT. We don't know what their main differences are and >which one we should use. Any information regarding this subject or any >recommendation will be very appreciated. > >Thanks in advance > >Ling > >