Static DB Viewer

**Uleat** · #1 11-15-2012, 10:35 PM

Hey guys!

Is there a good program that will allow a static (non-server) database for peq?

Worst case, I guess I could try building a .sdf file and just accessing it through VS.

(This is for my non-HT laptop, which does't have the resources to run a server service. I just want to be able to see the entries..and possibly query them.)

lerxst2112 · #2 11-15-2012, 10:44 PM

Not really sure what you're asking, but MySQL is easily configured to use very little resources.

**Uleat** · #3 11-16-2012, 12:21 AM

I may have to play around with mysql then. I'm out of room on my laptop...

I sit at 50% mem usage with nothing open and have less than 5GB left on this drive. I'm just trying to figure out how to locally access a peq database with the
least resource usage.

I had thought about trying to load the peq db into a SQL CE database file and just using VS to read it, but I guess I could do it using mysql instead of CE.

Thanks Lerxst!

sehall · #4 11-16-2012, 11:45 AM

It's probably best if you do use Mysql or another SQL database that's really ANSI compliant. SQL Server has issues when attempting to execute the SQL scripts directly into it. (data types, syntax). It'd take a lot of work to make the script readable by SQL Server. I'm a DB programmer that works on SS full time, and I attempted to see if I could get the data into SS but there were too many issues.

**Uleat** · #5 11-16-2012, 05:56 PM

Roger that and thanks for the heads up!