Also will probably add something to this effect to get the default location and move the items there by default (code from different project):

    private string GetDefaultLocation(OleDbConnection conn)
    {
        string default_location = string.Empty;
        try
        {
            string sql =
            @" declare @SmoDefaultFile nvarchar

(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', @SmoDefaultFile OUTPUT

                SELECT @SmoDefaultFile";

            OleDbCommand command = new OleDbCommand

(sql, conn); default_location = (string) command.ExecuteScalar(); } catch (Exception ex) { Log.LogError("Error getting default location from the database: " + ex.Message); }

        return default_location;
    }

Might also want to take care of renaming the logical file as well to match the name of the database:

http://timothychenallen.blogspot.com/2007/02/sql-server-how-to-change-database- file.html

http://www.mssqltips.com/tip.asp?tip=1891&home

http://thedebugger.blogspot.com/2006/04/mssql-how-to-change-logical-file-name.html

There is actually an easier way to get to this information: https://github.com/chucknorris/roundhouse/issues/9

Fixed in revision 336

Is it possible to just specify a path where I want the db and log files to get moved to? Like /moveToPath="e:\data".

Notice the name of this enhancement was "if one has not been specified"? :D

https://github.com/chucknorris/roundhouse/wiki/ConfigurationOptions

The section on Restore has a restorecustomoptions

--rco, --restoreoptions, --restorecustomoptions=VALUE | RestoreCustomOptions - This provides the restoreany custom options as in MOVE='Somewhere or another'.

You have to fully comply with T-SQL though, not just a location. It becomes part of a T-SQL restore script.

http://msdn.microsoft.com/en-us/library/ms186858(v=sql.90).aspx

Hehe, I know about the custom option :) I'm already rolling my own restor script alongside Roundhouse so I was trying to get away from that, just specifying a path. Will this be possible to do with RH?

The new token replacer may be something that helps out with the names of the files.

{{DatabaseName}}

https://github.com/chucknorris/roundhouse/wiki/TokenReplacement

But since you're already moving db files to the default location, wouldn't it be easy to make it configurable?

@goran, log a separate issue and we can prioritize it. Thanks.