从 VIsual Studio 导出 sql server 注册信息 [英] Export sql server registration info from VIsual Studio

问题描述

如何导出在 SQL Server 对象资源管理器中注册的所有 sql server?

how can i export all my sql server registered in SQL Server Object Explorer?

我尝试了导入和导出设置，但它没有保存它们

I try Import and export settings but it dont save them

推荐答案

据我所知，没有内置机制可以保存和恢复这些设置.连接字符串数据保存在注册表

To my knowledge there's not a built-in mechanism that will save and restore these settings. The connection string data is saved in the registry under

 HKEY_CURRENT_USER\SOFTWARE\Microsoft\SSDT\ConnectionStrings

所以你也许可以从那里导出设置.

so you could perhaps export the settings from there.

关于编辑注册表危险的标准免责声明一如既往地适用.

The standard disclaimers about editing the registry being dangerous apply, as always.

这篇关于从 VIsual Studio 导出 sql server 注册信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！