Local database deployment problems and fixtures
/*By Jiangong SUN*/
After encountering some problems in deploying databases to local server, here are some tips which could be helpful in the database deployment exercises.
When you deploy your databases. You can monitor the progress in "Data Tools Operations" view.
The deployment can have all the following steps:
Step 1. Creating publish preview
Step 2. Creating database script
Step 3. Executing publish script on database ‘Your database‘.
Step 4. Publish completed successfully
In my experience, the failure in Step 1 could happen when you generate the database script.
If you have this problem, build the project and retry.
In Step 2 you could meet a problem like : the script file could not be found
In this case, just locate your project folder and find the file "{DB_Name}.dbmdl" and delete it. Then retry.
In other cases, if the database script is correctly generated and there is a problem, you can even execute and debug the script "{DB_Name}_{Publish_Number}.publish.sql".
If you meet the problem at Step 3, you can click on "View Results" to locate where the problem is.
If you can‘t locate the problem, just debug the generated SQL script.
I hope this post can do help to you!!!
Enjoy coding!
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
