SQL means Structured Query Language. It is the language of databases, and there are slight variations depending on which database you are talking to.
Tasks of "database administration" (making new databases, viewing the contents of a database, etc) will vary with the DB's implementation. As far as inserting, updating, and deleting from C#, the actual database implementation won't matter for the most part.
To make your app talk to the DB you have to worry about the connection string & ODBC drivers.
Administrative tasks can be done via an IDE like RazorSQL, or they can be done via a SQLite command line. Additionally, you could code the C# to create your DB and populate its schema, etc.
Is the original drive c? If not, move files, keeps paths, move drive letter.
The other option is an alternative database editing tool that will let you edit the tables. Maybe: http://razorsql.com/features/sqlite_table_editor.html
Keep in mind that path changes will mess up you image caches, at least it used to.
my colleagues use razorsql, I prefer cqlsh myself though.
The thing that I hate most about DevCenter is its appetite to eat more and more of memory. Plus, the stupid limitations of how many rows you can retrieve. Like What the hell? We raised this concern to DataStax back when we had DevCenter 1.4, but until now (1.6), it's still the same
.BAK is just an extension, usually created as a backup to the original file. You can still read the file in an appropriate program.
After a quick search is appears that BES, Blackberry Enterprise Server, uses Microsoft SQL as a database server. So, you would need a program to read MS SQL database.
You could go through the hassle of mounting it to a SQL Server or use a free SQL Express, but I just did a quick search and found a SQL reader called RazorSQL