Recently, many students asked a question, how to export MSSQLSERVER database and the data inside the SQL Script , the main question is MSSQLServer2000 and 2005, because 2008 of the manager has this feature, 2000 and 2005 are not.
Surf the internet for a bit, useful commands or something, here's a relatively simple and easy-to-use approach:
Need a tool----Navicat Premium
Navicat Premium A very powerful database management tool, you can connect to MySQL, SQLite, Oracle SQL Server, and PostgreSQL and so on, purchase registration, but the online registration code, download it can be downloaded to cracked version, limited to learning, Please support Genuine!!!!
No more nonsense, get to the chase:
1. Connect to your SQL Server database with Navicat Premium, and do not connect yourself to Baidu;
2. After the connection is successfully opened, you will see all of your SQL Server databases;
3. Select the database to export, right----data transfer;
4. Settings See:
5: Click to start, there will be a log display, and finally close.
I exported the file:
"Original" SQL Server methods for exporting data to SQL scripts