Elastic DB Tools for Azure SQL - ShardSqlCmd

This sample provides a command-line interface similar to the SQLCMD Utility that allows you to execute Transact-SQL queries across a shard set using shard map manager and multi-shard query functionality available via the elastic database client library for Azure SQL DB.

C# (106.7 KB)
5 Star
512 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question

  • can't connect to Azure
    2 Posts | Last post October 22, 2014
    • believe I have put in the correct connection information but doesn't seem to connect.  no errors, no output, just re-displays the connection params each time so not sure what I am doing wrong.  
    • -S, -d, and -sm must all be specified, for Azure (which doesn't support Windows Auth) both -U and -P must be specified. You can see the code for this in the IsValid method.
      /// <summary> 
      /// Gets a value indicating whether the command line is valid, i.e. parsing it succeeded. 
      /// </summary> 
      public bool IsValid 
              // Verify that a correct combination of parameters were provided 
              return this.ServerName != null && 
                     this.DatabaseName != null && 
                     this.ShardMap != null && 
                     (this.UseTrustedConnection || 
                      (this.UserName != null && this.Password != null)) &&