A lot of people use the high version of the database to do the job, and then submit the time can not be restored or attached, how to do? 0 minutes?
For the following two questions, a solution was proposed: "Express does not seem to have this function" 1, high version compatible with the lower version, the lower version does not recognize the high version is already recognized, what is the way to a little snack? 2, inverse days, we used to have a script with Oracle to export, SQL How can not find ah?
There is a picture of the truth: 1, right-click the database----and generate script 2. All points next, all the way down to this--and set save path--Advanced
3, on-demand choice, if you do not know the selection of true--> general there is a choice version (which version of SSMs you want to choose) "School is 2008"
4, this step is the most important choice of what you want to export is the schema or data or both export "if you just want to solve the version problem, select the schema and data"
5, the results of the final export 6, put the SQL source file into the database to execute a SQL command is OK, version of the problem is so bypassed ~ ~ "This SQL source file is called the script."
|
"SQL" resolves conflicts between SQL versions