Export-import sql database dump

[nicky_net]

Hi,
I am getting problem while export-import (database schema including data)
sql database dump(.sql file) in vb.net code. Can any one give me a hint or a code snippet for that please its urgent.. help me.,.........


Thanks

in Advance

Nicky

 

[jmcilhinney]

Maybe you could give us a hint or code for what you're doing now that isn't working, and an indication of what goes wrong. If you only have one line wrong then there's no need for us to waste our time giving an entire solution. Make it as easy as possible for people to help you and you are more likely to receive help.

 

[nicky_net]

Hi,
Actully i don't have any code written for that till now.. i am searching for backup my database schema (all tables) including data in SQLite database using Vb.net..



Dim connectionString AsString = "Data Source=C:\stats\database.db3;"
Dim fact As Common.DbProviderFactory = Common.DbProviderFactories.GetFactory("System.Data.SQLite")
' Using
Dim myConnection As Common.DbConnection = fact.CreateConnection
Try
myConnection.ConnectionString = connectionString
myConnection.Open()
Catch ex As Exception

EndTry
Dim dbcmd AsNew Data.SQLite.SQLiteCommand
dbcmd = myConnection.CreateCommand
dbcmd.CommandText = " " '? query i am searching for, runs with Sqlite database..

dbcmd.ExecuteNonQuery()
myConnection.Close()