本文介绍了一个名为SQLExpressUtility的工具，它允许您轻松地与SQLExpress服务器进行交互，包括连接到主要实例或用户实例、创建、附加、分离数据库、升级数据库文件、执行SQL语句、获取服务器版本、启用和禁用跟踪标志、列出本地或远程服务器实例、检查点和收缩数据库、测量特定查询性能、为服务器执行SQL命令列表以及记录所有输入和输出。
可否通过命令行创建SQL Express数据库文件? ScottGu 的提到了一个工具SQL Express Utility
SSEUtil.exe is a tool that lets you easily interact with SQL Server. Among other things, it allows you to:
• Connect to the main instance or user-instance of SQL Server.
• Create, attach, detach, and list databases on the server.
• Upgrade database files to match the version of the server.
• Execute SQL statements via the console (similar to SQLCMD).
• Retrieve the version of SQL Server running.
• Enable and disable trace flags (for example, to trace SQL statements sent to the server by any client application)
• List the instances of SQL Server on the local machine or on remote machines.
• Checkpoint and shrink a database
• Measure the performance of executing specific queries.
• Create and playback lists of SQL commands for the server to execute.
• Log all input and output.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
