Ok this is a bit tricky because phpmyadmin has direct import. But there is some good out there with which we .Net developers can live with.
you can do following steps.
Run your sql server configuration manager and configure your TCiP=> enabled and restart sql service
Login to Plesk create database and add user to it.
Create ODBC SQL connection there.
Replace (local) with the your website DNS(ip) and manage rest of settings. Note that you have to provide username and password here that you added for db user
Test the connection if it is a success then you are almost done
In your SQL server Management Studio you connect using above credentials (server add,username and Pass)
If successful you would be connected and see the database you created there.
You can right click database and GOTO Tasks->Import and Export from that wizard you need to select the appropriate source and then wizard will guide you all the way.
发布评论
评论（1）
好吧，这有点棘手，因为 phpmyadmin 可以直接导入。但也有一些我们 .Net 开发人员可以接受的好东西。
您可以执行以下步骤。
TCiP=>启用并重新启动 sql 服务Plesk创建数据库并向其中添加用户。(local)替换为您的网站DNS(ip)并管理其余设置。请注意，您必须在此处提供为 db 用户添加的用户名和密码任务->导入和导出，您需要选择适当的源，然后向导将全程指导您。就这样吧......
快乐编程:)
Ok this is a bit tricky because
phpmyadminhas direct import. But there is some good out there with which we .Net developers can live with.you can do following steps.
TCiP=> enabled and restart sql servicePleskcreate database and add user to it.(local)with the your websiteDNS(ip)and manage rest of settings. Note that you have to provide username and password here that you added for db userTasks->Import and Exportfrom that wizard you need to select the appropriate source and then wizard will guide you all the way.there you go......
Happy Programming :)