Expose server name/URL via azdata.ServerInfo

[zijchen]

Is your feature request related to a problem? Please describe.
ServerInfo is used to determine the target platform when creating a database project from an existing database. Unfortunately, Fabric DW has the same engine edition as Serverless DW (OnDemand) and the only way to differentiate the two is from the server URL.

Describe the solution or feature you'd like
The server URL be accessible via azdata.ServerInfo
https://github.com/microsoft/azuredatastudio/blob/25a658775c1de09448625410d9b12a2771d147ac/src/sql/azdata.d.ts#L530C19-L530C29

Describe alternatives you've considered
In #24014 I am using the server name from the ConnectionProfile, but it only works if the connection is already selected prior to creating a project (via the list of connections). There is no way to get the server name after using this dialog to select a connection:

Additional context
Server name is accessible via vscode-mssql

azuredatastudio/extensions/types/vscode-mssql.d.ts

Lines 237 to 241 in 25a6587

	export interface IConnectionInfo {
	/**
	* server name
	*/
	server: string;

[Charles-Gagnon]

serverName is in the connection info

azuredatastudio/src/sql/azdata.d.ts

Line 415 in 25a6587

serverName: string;

Is there some reason you need it in the server info as well?

[zijchen]

This may just be my limited knowledge of the azdata API. Here is the callback from the "Create Project From Database" dialog

azuredatastudio/extensions/sql-database-projects/src/controllers/projectController.ts

Lines 1589 to 1605 in 6c6464e

	public async createProjectFromDatabaseCallback(model: ImportDataModel, connectionInfo?: string | mssqlVscode.IConnectionInfo) {
	try {
	const newProjFolderUri = model.filePath;
	let targetPlatform: SqlTargetPlatform | undefined;
	let serverInfo;
	if (connectionInfo) {
	if (typeof connectionInfo === 'string') {
	serverInfo = await utils.getAzdataApi()!.connection.getServerInfo(connectionInfo);
	} else {
	serverInfo = (await utils.getVscodeMssqlApi()).getServerInfo(connectionInfo);
	}
	}
	if (serverInfo) {
	targetPlatform = await utils.getTargetPlatformFromServerVersion(serverInfo);
	}

ConnectionInfo is a string here, which I believe is the GUID of the connection in ADS. It then uses it to call getServerInfo to get more details. If there is a way to get the IConnectionProfile object from the GUID, I'd be happy to try it out.

[Charles-Gagnon]

Try this :

const connectionUri = await azdataApi!.connection.getUriForConnection(connectionInfo);
const connectionProfile = await azdataApi!.connection.getConnection(connectionUri);

(while you're at it, I would update the param name to connectionIdOrInfo to more accurately represent what it is)