How can we help you today? How can we help you today?

Getting .Net SqlClient Data Provider calls from redgate tool

Howdy. Would like to request that y'all change one of the SQL Source Control/SQL Compare connection strings so that the application name shows up properly.

I ran a trace, and during it had a coworker run a SQL Compare scan. He also has SQL Source Control installed. The SQL Compare showed up properly in the trace: (Red Gate Software - SQL Tools)

However, for the following call, the application name shows up as ".Net SqlClient Data Provider", which is the generic name SQL Server uses if there's nothing in the connection string.

Can I please get that changed so that it shows as "Red Gate Software - SQL Tools" too, please?

Code called: 
SELECT revisions.value AS Revision, scripts.value AS ScriptsLocation, migrations.value AS MigrationScriptsLocation
                    FROM [ERXPAD].sys.extended_properties AS revisions
                    JOIN [ERXPAD].sys.extended_properties AS migrations
                    ON migrations.minor_id = revisions.major_id
                    JOIN [ERXPAD].sys.extended_properties AS scripts
                    ON revisions.minor_id = scripts.minor_id
                    WHERE revisions.name = 'SQLSourceControl Database Revision'
                    AND migrations.name = 'SQLSourceControl Migration Scripts Location'
                    AND scripts.name = 'SQLSourceControl Scripts Location';
mbourgon
0

Comments

3 comments

Sort by
  • Mark J
    Sounds sensible to me - I've written this up as SC-8023. Hopefully it should be a quick change :)
    Mark J
    0
  • Mike U
    Hi,

    I'm glad to tell you that we've fixed this in the latest frequent updates version of SQL Compare, 11.3.1.56. If you haven't already, you'll need to turn on frequent updates to get it.
    Mike U
    0
  • mbourgon
    Wow, that was quick! Thanks!
    mbourgon
    0

Add comment

Please sign in to leave a comment.