TCP::payload replace and MSSQL

Hello,

 

 

I'm trying to figure out away to change the database value within a SQL connection string as it passes through the Big-Ip on the way to the DB server.

 

 

I'm guessing that I need to do a "TCP::collect" and then search for a specific string (the db name the client is using ) then use "TCP::payload replace" to change it to the Db name I want to use.

 

 

Unfortunatly I have no idea how to approach this. Can anyone help? or is there a better way to do this?

 

 

Cheers

 

Simon