SQL Version Migration

Have you ever encountered a situation where you started with a high-version SQL Server, but the server was using a lower version of SQL and there was an incompatibility problem.

650) this.width=650; "title=" qq20141130163527.jpg "style=" Float:none "alt=" wkiol1r64jmdoj6raaflwiwgzai694.jpg "src = "Http://s3.51cto.com/wyfs02/M02/54/2A/wKioL1R64JmDOj6RAAFLwIWgZaI694.jpg"/>

A version migration is required at this point.

1. The script file is generated in a higher version of the environment first.

650) this.width=650; "title=" qq20141206211836.jpg "style=" Float:none "src=" http://s3.51cto.com/wyfs02/M01/54/75/ Wkiol1sdft6thhpzaau1pvu6ctg170.jpg "alt=" Wkiol1sdft6thhpzaau1pvu6ctg170.jpg "/>

Need to set

650) this.width=650; "title=" qq20141206211932.jpg "style=" Float:none "src=" http://s3.51cto.com/wyfs02/M00/54/76/ Wkiom1sdfk7i3jf0aafyzlvjmy4515.jpg "alt=" Wkiom1sdfk7i3jf0aafyzlvjmy4515.jpg "/>

Select Type

650) this.width=650; "title=" qq20141206212017.jpg "style=" Float:none "src=" http://s3.51cto.com/wyfs02/M01/54/75/ Wkiol1sdfuch5mroaagq68geijo891.jpg "alt=" Wkiol1sdfuch5mroaagq68geijo891.jpg "/>

650) this.width=650; "title=" qq20141206212039.jpg "style=" Float:none "src=" http://s3.51cto.com/wyfs02/M01/54/76/ Wkiom1sdfldbosnwaafsyvx_qdo936.jpg "alt=" Wkiom1sdfldbosnwaafsyvx_qdo936.jpg "/>

Then to the lower version, open the script.

Click Execute and you will find that the database does not exist.

Turn off management to reopen, and you will find that the database has been automatically established (without creating a new one yourself) to continue the execution.

If there is an error in execution, try to execute it several times.

650) this.width=650; "title=" qq20141206212218.jpg "style=" Float:none "src=" http://s3.51cto.com/wyfs02/M02/54/75/ Wkiol1sdfuxgsdy1aatjtgf6xw4033.jpg "alt=" Wkiol1sdfuxgsdy1aatjtgf6xw4033.jpg "/>

SQL Version Migration