danhaywood

declare @sql varchar(max), @on_clause varchar(max)

SELECT
    @on_clause = CASE
        WHEN @on_clause IS NULL THEN 'NAME = ' + name + ', FILENAME = ''' + physical_name + '.ss'''
        ELSE @on_clause + ', ' + 'NAME = ' + name + ', FILENAME = ''' + physical_name + '.ss'''
    END
FROM
    sys.database_files df
	where type_desc = 'ROWS'

danhaywood

-- run in the target database
-- (but there must be no other logins using that database otherwise will fail).

declare @sql varchar(max)

set @sql = 'RESTORE DATABASE ' + DB_NAME() + ' FROM DATABASE_SNAPSHOT = ''' + DB_NAME() + '_snapshot'''

use master

danhaywood

sudo apt-get update

# java
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer
java -version

# maven
sudo apt-get install maven

danhaywood

#!/bin/bash

#
# usage:
#   . j8
#

JH8=$(echo $JAVA_HOME8 | sed 's/\\/\//g' | sed 's/C:/\/c/ig')
JH11=$(echo $JAVA_HOME11 | sed 's/\\/\//g' | sed 's/C:/\/c/ig')
JH8_bin="${JH8}/bin"

danhaywood

#!/bin/bash

#
# usage:
#   . j11
#

JH8=$(echo $JAVA_HOME8 | sed 's/\\/\//g' | sed 's/C:/\/c/ig')
JH11=$(echo $JAVA_HOME11 | sed 's/\\/\//g' | sed 's/C:/\/c/ig')
JH8_bin="${JH8}/bin"