storing mysql data to a random access file

5 Mar 2006 2:28 AM

VB.NET

I'm using a mysql database and connecting my vb.net program to the DB over a
network connection. i would like to bring this data over to a vb.net random
access file. does anyone know how to convert my DB into a binary file? and
how to convert my code to use a file instead of the db?

5 Mar 2006 2:50 PM

Ken Tucker [MVP]

Hi,

If you store the data in random access file you will lose the
ability to query the data. I think it might be better to install a copy of
mysql on your local machine and making a local copy of the database to work
with. My Sql is open source and can be downloaded from dev.mysql.com.
Another option is move the database to sql express which is also free from
microsoft.

Ken
---------------

Show quoteHide quote

"VB.NET" wrote:

> I'm using a mysql database and connecting my vb.net program to the DB over a
> network connection. i would like to bring this data over to a vb.net random
> access file. does anyone know how to convert my DB into a binary file? and
> how to convert my code to use a file instead of the db?
>
>
>

5 Mar 2006 4:27 PM

VB.NET

Show quote Hide quote

"Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in message
news:DC2E022E-DE0D-4C84-A0C8-EA43D8FE6CC1@microsoft.com...
> Hi,
>
> If you store the data in random access file you will lose the
> ability to query the data. I think it might be better to install a copy
> of
> mysql on your local machine and making a local copy of the database to
> work
> with. My Sql is open source and can be downloaded from dev.mysql.com.
> Another option is move the database to sql express which is also free from
> microsoft.
>
> Ken
> ---------------
>
> "VB.NET" wrote:
>
>> I'm using a mysql database and connecting my vb.net program to the DB
>> over a
>> network connection. i would like to bring this data over to a vb.net
>> random
>> access file. does anyone know how to convert my DB into a binary file?
>> and
>> how to convert my code to use a file instead of the db?

Is there any way to hold data, and do queries on it, but make it file based,
so the data can be transported w/ the program?

5 Mar 2006 6:17 PM

Ken Tucker [MVP]

Hi,

         You have a couple of options here. First you could move the data
to an access database. Access is a file based database which does not
require any database server to be installed.

          Sql express is a free version of sql server 2005 which will allow
you to attached a database file to the server. The computer running the
application is required to have sql express installed.

http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp

          LINQ is a preview to a new techology to be offered in the next
version of visual basic which will allow you to query classes. You could
create a class which contains all the data in the database and store it in a
file. Understand this is a early beta and there is no guarantee that code
you write now will still work when LINQ is released. Here is a link to info
on LINQ. (I recommend you install betas on virtual pc or virtual server)

http://msdn.microsoft.com/netframework/future/linq/

Ken
--------------------
Show quoteHide quote

"VB.NET" wrote:

> "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in message
> news:DC2E022E-DE0D-4C84-A0C8-EA43D8FE6CC1@microsoft.com...
> > Hi,
> >
> > If you store the data in random access file you will lose the
> > ability to query the data. I think it might be better to install a copy
> > of
> > mysql on your local machine and making a local copy of the database to
> > work
> > with. My Sql is open source and can be downloaded from dev.mysql.com.
> > Another option is move the database to sql express which is also free from
> > microsoft.
> >
> > Ken
> > ---------------
> >
> > "VB.NET" wrote:
> >
> >> I'm using a mysql database and connecting my vb.net program to the DB
> >> over a
> >> network connection. i would like to bring this data over to a vb.net
> >> random
> >> access file. does anyone know how to convert my DB into a binary file?
> >> and
> >> how to convert my code to use a file instead of the db?
>
> Is there any way to hold data, and do queries on it, but make it file based,
> so the data can be transported w/ the program?
>
>
>