Re: What Database model should I use?

On Fri, 1 Jul 2005 06:35:07 -0700, "George H. Slamowitz" <GSlamowitz@xxxxxxx> wrote:

¤ That is assuming that :
¤
¤ (1) you are converting to MS SQL Server
¤ (2) you are staying with MS Access
¤
¤ (1) I'm not sure which SQL Server I'm going to convert to ... MS SQL Server
¤ for this application is very expensive, it's low on the list, but not ruled
¤ out
¤
¤ (2) I'm currently converting the application to VB6
¤
¤ That's why the delema!

You may also want to ask yourself how many users will this database system need to support and what
will be the concurrent usage.

If SQL Server is out of your price range then Oracle will be way out of your price range.


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: If ACCESS 2002 is the back end database for VB6, then should I use ADO???
    ... ¤>> Just google ~MSDE won't run on Vista~ and read it and weep. ... ¤>"As part of this push we have made the decision to not support MSDE on ... MSDE didn't cost you anything anyway, nor does SQL Server 2005 Express. ...
    (microsoft.public.vb.general.discussion)
  • Re: What Database model should I use?
    ... I'm not sure which SQL Server I'm going to convert to ... ... I'm currently converting the application to VB6 ... > ¤ I have been programming in microsoft access for years. ... upgrade the JET engine to a real SQL database, ig SQL Serever, Orical, MySQL ...
    (microsoft.public.vb.database)
  • Re: If ACCESS 2002 is the back end database for VB6, then should I use ADO???
    ... ¤>¤ That's what is so sad. ... ¤>MSDE didn't cost you anything anyway, nor does SQL Server 2005 Express. ... MSDE may run on Vista but it and SQL Server ... But hey, if you can get great support for what just became an open source product, ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy database schema from Access to SQL Server
    ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ... template database and the target database and compare their schemata. ...
    (microsoft.public.dotnet.framework.adonet)