此处以数据库管理工具 Navicat 为例 连接mysql数据库:打开 Navicat 软件,点击“文件”,选择“新建连接”,选 择“MySQL”。 ![image](https://www.zzidc.com/upload/image/20150410/97651428630126568.jpg)
填写连接数据库的信息,如图: ![image](https://www.zzidc.com/upload/image/20150410/68071428629654571.jpg)
数据库信息填写完整后,点击“确定”,信息填写正确,则连接成功,如图: ![image](https://www.zzidc.com/upload/image/20150410/40541428630229483.jpg)
导入数据,右击“数据库名字”,点击“运行SQL文件” ![image](https://www.zzidc.com/upload/image/20150410/43741428630620634.jpg)
选择sql文件,编码选择“UTF-8”,“遇到错误继续”不要勾选,点击“开始”如图: ![image](https://www.zzidc.com/upload/image/20150410/78421428630750958.jpg)
导入成功,提示如下截图: ![image](https://www.zzidc.com/upload/image/20150410/24971428630876255.jpg)
连接mssql数据库:打开Navicat软件,点击“文件”,选择“新建连接”,选择“SQL Server”; ![image](https://www.zzidc.com/upload/image/20150410/41661428630975895.jpg)
填写连接数据库的信息,如图: ![image](https://www.zzidc.com/upload/image/20150410/3531428631066607.jpg)
数据库信息填写完整后,点击“确定”,信息填写正确,则连接成功,如图: ![image](https://www.zzidc.com/upload/image/20150410/21681428628905965.png)
导入数据,右击“数据库名字”,点击“运行SQL文件” ![image](https://www.zzidc.com/upload/image/20150410/4251428631199175.jpg)
选择SQL文件,编码选择“UTF-8”,“遇到错误继续”不要勾选,点击“开始”如图: ![image](https://www.zzidc.com/upload/image/20150410/97471428631274840.jpg)
|