search

EVE-SECURE / evemarketmonitorapp

Automatically exported from code.google.com/p/evemarketmonitorapp
0 stars 0 forks source link

Request: mdb Access format #29

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Requesting to be able to have databases in .mdb format (or any format not
requiring a windows server 2005 install).  When using multiple computers
and not having access to a central windows server to install SQL Server
2005 on, this makes for use on multiple computers impossible since the data
is only on one or the other computer.  

Putting a .mdb file on a linux based nas box makes the data accessible to
multiple computers (several other apps like evehq use this format. it isnt
the fastest, but it works).

What is the expected output? What do you see instead?
To be able to use the same database across several computers without
requiring an install of sql server 2005.

What version of the product are you using? On what operating system?

Latest, on vista and win 7.

Please provide any additional information below.

Original issue reported on code.google.com by scott...@gmail.com on 22 Aug 2009 at 2:48

GoogleCodeExporter commented 9 years ago 
Changing the system to use an access database would be a huge task. I believe 
some 
CLR stored procedures would not be migratable to access and many other database 
operations would suffer a performance hit.

I believe the best way to achieve the aim here would be to setup the EMMA 
database on 
one machine as an ODBC datasource, import the data into access and then 
distribute 
the resulting database as required.

This is rather cumbersome but changing EMMA to use Access (or any other DBMS) 
is 
simply not an option imo.

Original comment by SteveBal...@gmail.com on 24 Sep 2009 at 3:57