Local database deployment problems and fixtures
来源:互联网 发布:网络布线 编辑:程序博客网 时间:2024/06/05 12:12
/*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!
- Local database deployment problems and fixtures
- export out remote database and inport into local database
- LeetCode Database Problems
- How to set up ADB for remote machine development and local device deployment
- Generate Local Database
- [转载]html5 local database
- VCM tips: jar deployment path/install default user name and password/Oracle database schema clean/VPD file clean
- Smoking and Dental Problems
- Problems and Opportunities
- U3: Problems and solutions
- The database has local access protection and you are not authorized to access it locally
- Software Deployment, Updating, and Patching
- Windows Deployment and Resource Kits
- Identifying Read/Write (I/O) Problems - Database
- Rails 2.2 and MySQL Problems
- Some Sharepoint problems and resolutions
- Problems with JSPDF and AutoTable
- database quiesce and database suspend
- elastic
- INVOKE ADDR PROC PROTO
- Memcached 二进制协议(BinaryProtocol) incr指令泄露内存数据的bug
- lamp 的搭建与 gdb反编译hello world
- 大学--学到的是什么
- Local database deployment problems and fixtures
- Chromium Graphics Update in 2014(幻灯片)
- Sicily 1029. Rabbit【高精度加法】
- Hibernate 表关系描述之ManyToMany
- Hive编程指南学习笔记(1)
- 最长递减子序列 【微软面试100题 第四十七题】
- Android Launcher3源码分析与修改
- Get和Post的区别
- JAVA——jdk安装