Importing a SQLServer Schema using java

[Ronan Dowd]

Hi All,

Does Java have any support for importing a SQL Server database ?

I have a SQL Server database schema which I've backed up. So it's called something like "ms-schema.bak"

Basically my application needs to take in as input a database backup (i.e a bak file) and actually restore the database

Any help would be great on this..

Thanks, Ro.

[Henry Wong]

Here is the JDBC driver for SQL server...

http://msdn.microsoft.com/en-us/data/aa937724.aspx

With this, you should be able to get to SQL server, with Java via JDBC. Now, how to do the restore and stuff, I guess that is a SQL server capability.

Henry

[Steve Luke]

I did a little search, and it seems that there are SQL commands for restoring a database. See: this Google Search. What commands and how to use them depend on version of SQL Server, and where your files are stored.

Some of those search returns suggest there is a command line you can use to restore a DB, but I didn't read enough to know if it was custom written, builtin to the the SQL Server bin directory, or a third party product.

[Rob Spoor]

Moving to JDBC