On Mon, Nov 13, 2006 at 08:51:25PM -0000, Ashok122 wrote:

> I want to do this in Java.
>
> But I am not sure about getting a Connection object without Database
> is first created.
>
> Because it is possible to use executeUpdate with
> Create Database 'NewDB.fdb' user 'sysdba' password 'masterkey'
> page_size 2048
>
> before I can use above statement, I need to get the Connection to the
> database which does not yet exist.
>
> or
>
> If someone knows how to do this using Service API / FBBackupManager, I
> would appreciate the Source Code example.
>

You can indeed do it with the FBBackupManager. The following code should
do it:

BackupManager mgr = new FBBackupManager();
mgr.setUser("sysdba");
mgr.setPassword("masterkey");
mgr.setHost("somehost");
mgr.setVerbose(true);
mgr.setLogger(System.out);
mgr.setDatabase("/path/to/db.fdb");
mgr.setBackupPath("/tmp/backed_up.fbk");
mgr.backupDatabase();
mgr.setRestorePageSize(2048);
mgr.setRestoreReplace(true);
mgr.restoreDatabase();


- Gabriel