C:\>sqlcmd /? Microsoft (R) SQL Server Command Line Tool Version 10.50.2500.0 NT x64 Copyright (c) Microsoft Corporation. All rights reserved.
Install the vmc-IronFoundry gem
C:\>gem install vmc-IronFoundry --pre Fetching: vmc-IronFoundry-0.3.16.IF.1.gem (100%) Successfully installed vmc-IronFoundry-0.3.16.IF.1 1 gem installed Installing ri documentation for vmc-IronFoundry-0.3.16.IF.1... Installing RDoc documentation for vmc-IronFoundry-0.3.16.IF.1...
You also need to install the Caldecott gem. Currently one of its dependencies has to be explicitly installed first:
C:\>gem install eventmachine --pre Fetching: eventmachine-1.0.0.beta.4.1-x86-mingw32.gem (100%) Successfully installed eventmachine-1.0.0.beta.4.1-x86-mingw32 1 gem installed Installing ri documentation for eventmachine-1.0.0.beta.4.1-x86-mingw32... Installing RDoc documentation for eventmachine-1.0.0.beta.4.1-x86-mingw32...
Then you can install Caldecott:
C:\>gem install caldecott Fetching: caldecott-0.0.5.gem (100%) Successfully installed caldecott-0.0.5 1 gem installed Installing ri documentation for caldecott-0.0.5... Installing RDoc documentation for caldecott-0.0.5...
Target api.ironfoundry.me and log in to your account
C:\>vmc target api.ironfoundry.me Successfully targeted to [http://api.ironfoundry.me] C:\>vmc login --email firstname.lastname@example.org --passwd XXXYYYZZZ Attempting login to [http://api.ironfoundry.me] Successfully logged into [http://api.ironfoundry.me]
Provision an MS SQL database
C:\>vmc create-service mssql Creating Service [mssql-c902d]: OK
Tunnel to your database
C:\>vmc tunnel mssql-c902d sqlcmd Deploying tunnel application 'caldecott'. Uploading Application: Checking for available resources: OK Packing application: OK Uploading (1K): OK Push Status: OK Binding Service [mssql-c902d]: OK Staging Application 'caldecott': OK Starting Application 'caldecott': OK Getting tunnel connection info: OK
Service connection info:
username : uxeBbNM0jYAFS password : psOmxGWibimeX name : d7dedaf7e01ae42568c07c44ec30bff99
Starting tunnel to mssql-c902d on port 10000. Launching 'sqlcmd -S localhost,10000 -U uxeBbNM0jYAFS -P psOmxGWibimeX -d d7dedaf7e01ae42568c07c44ec30bff99'
You can now run commands from within sqlcmd against your database!
1> select @@VERSION 2> GO
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
In addition, you can use the displayed connection information to connect via SQL Management Studio. Just use localhost,10000 as the "Server name". Be sure to start the tunnel first and keep it open during the time you're using Management Studio. Quitting sqlcmd will close the tunnel.