Recently, many people asked a question about how to export the database and data in MSSQLServer as SQL scripts. The main question is MSSQLServer2000 and 2005, because the manager of 2008 already has this function, 2000 and 2005 do not exist. I checked on the Internet and used commands. Here I will introduce a relatively simple and easy-to-use method:
Recently, many people asked a question about how to export the database and data in MSSQLServer as SQL scripts. The main question is MSSQLServer2000 and 2005, because the manager of 2008 already has this function, 2000 and 2005 do not exist. I checked on the Internet and used commands. Here I will introduce a relatively simple and easy-to-use method:
Recently, many people asked a question:MSSQLServer database and data in it are exported as SQL scriptsThe main questions are MSSQLServer2000 and 2005, because the 2008 manager already has this function, and 2000 and 2005 do not.
I checked on the Internet and used commands. Here is a relatively simple and easy operation method:
A tool named Navicat Premium is required.
Navicat Premium is a powerful database management tool that can be connected to MySQL, SQLite, Oracle SQLSERVER, PostgreSQL, and so on. It has a registration code online, download it and download it to the cracked version. Only learning is supported. Please support genuine version !!!!
Start with the question:
1. Use Navicat Premium to connect to your SQLSERVER database. If it is not connected, please Baidu;
2. After the connection is successful, open the connection and you will see all your SQLSERVER databases;
3. Right-click the database to export and choose data transmission;
4. For settings, see:
5: Click start. The log is displayed. Close the log.
Finally, go to the C: \ Users \ Administrator \ Desktop \ directory and find the exported MySQL script. SQL file.