What is the easiest way to copy databases?

[Zalek Bloom]

Hello,

Using VB.Net for my PDA I created an application that is using a
database. This database is not password protected and not encripted.
Now I want to changed it - but I already populated all tables.
So wat is the easiest way to add to a database password and encription
option?

Thanks

Zalek

 

[Ginny Caughey [MVP]]

Zalek,

You didn't say which database you're using, but if it's SQL CE, the easiest
approach is to go here: www.primeworks.pt .

 

[Pete Vickers [MVP]]

Hi,
try our RemoteSQLCE - does this and loads more
http://www.gui-innovations.com/html/remotesqlce.html

Pete

 

[Zalek Bloom]

Hello,

Using VB.Net for my PDA I created an application that is using a
database. This database is not password protected and not encripted.
Now I want to changed it - but I already populated all tables.
So wat is the easiest way to add to a database password and encription
option?

Thanks

Zalek

Thanks to all for answers - yes it is SQL CE database.
I just found that Compact method will do what I want.
Here is the code:

SQLEngine = New SqlCeEngine("Data Source=" + "old database")
SQLEngine.Compact("Data Source="new database ; password='zalek';
encrypt database = True")

The "new database" is a copy of the "old database", password protected
and encrypted.

Zalek