Build 18.104.22.16805 I’ve got a connection where:
ServerName = IP Address of server
But the connection name is the customer name and a numeric identifier:
I’m connected to that connection, selected 4 tables, right-click, Generate SQL, DDL Script.
On clicking Build Script get error:
Build DDL Script
Connection IP ADDRESS
Can’t Find Connection ‘xxx.xxx.xxx.xxx’
I then went to the connection manager, added a new connection, gave it the same name as the server name (which in this case was just the IP address), and without even re-opening the Export DDL screen just clicked Build Script. This time the script was built successfully.
This is clearly a bug. We shouldn’t have to be naming the connections the same as the server name or IP Address of the server just to be able to run a DDL generation wizard.