Giải pháp đồng bộ dữ liệu sql trên linux
Chuyển đến nội dung chính Trình duyệt này không còn được hỗ trợ nữa. Show
Hãy nâng cấp lên Microsoft Edge để tận dụng các tính năng mới nhất, bản cập nhật bảo mật và hỗ trợ kỹ thuật. Export and import a database on Linux with SSMS or SqlPackage.exe on Windows
Trong bài viết nàyApplies to: SQL Server (all supported versions) - LinuxThis article shows how to use SQL Server Management Studio (SSMS) and SqlPackage.exe to export and import a database on SQL Server on Linux. SSMS and SqlPackage.exe are Windows applications, so use this technique when you have a Windows machine that can connect to a remote SQL Server instance on Linux. You should always install and use the most recent version of SQL Server Management Studio (SSMS) as described in Use SSMS on Windows to connect to SQL Server on Linux Note If you are migrating a database from one SQL Server instance to another, the recommendation is to use Backup and restore. Export a database with SSMS
The *.BACPAC file is successfully created at the location you chose and you are ready to import it into a target database. Import a database with SSMS
The *.BACPAC file is imported to create a new database in the target server you specified. SqlPackage command-line optionIt is also possible to use the SQL Server Data Tools (SSDT) command-line tool, SqlPackage.exe, to export and import BACPAC files. The following example command exports a BACPAC file:
Use the following command to import database schema and user data from a .BACPAC file:
See alsoFor more information on how to use SSMS, see Use SQL Server Management Studio. For more information on SqlPackage.exe, see the SqlPackage reference documentation. Phản hồiGửi và xem ý kiến phản hồi dành cho Chuyển đến nội dung chính Trình duyệt này không còn được hỗ trợ nữa. Hãy nâng cấp lên Microsoft Edge để tận dụng các tính năng mới nhất, bản cập nhật bảo mật và hỗ trợ kỹ thuật.
Trong bài viết nàyApplies to: SQL Server (all supported versions) - Linux There are several ways to manage SQL Server on Linux. The following section provides a quick overview of different management tools and techniques with pointers to more resources. mssql-confThe mssql-conf tool configures SQL Server on Linux. For more information, see Configure SQL Server on Linux with mssql-conf. Transact-SQLAlmost everything you can do in a client tool can also be accomplished with Transact-SQL statements. SQL Server provides Dynamic Management Views (DMVs) that query the status and configuration of SQL Server. There are also Transact-SQL commands for database management tasks. You can run these commands in any client tool that supports connecting to SQL Server and running Transact-SQL queries, for example sqlcmd or Visual Studio Code. Azure Data StudioThe new Azure Data Studio is a cross-platform tool for managing SQL Server. For more information, see Azure Data Studio. Named PipesThe Named Pipes protocol is not supported for SQL Server on Linux. SQL Server Management Studio on WindowsSQL Server Management Studio (SSMS) is a Windows application that provides a graphical user interface for managing SQL Server. Although it currently runs only on Windows, you can use it to remotely connect to your Linux SQL Server instances. For more information on using SSMS to manage SQL Server, see Use SSMS to Manage SQL Server on Linux. mssql-cli (preview)Microsoft has released a new cross-platform scripting tool for SQL Server, mssql-cli. This tool is currently in preview. PowerShellPowerShell provides a rich command-line environment to manage SQL Server on Linux. For more information, see Use PowerShell to Manage SQL Server on Linux. Next steps
Phản hồiGửi và xem ý kiến phản hồi dành cho |