Automatic deployment of SQLServerExpress databases and solutions-PHP Tutorial

Source: Internet
Author: User
Tags sql server express
Automatic deployment of SQLServerExpress databases and solutions. A program was developed over the past few days, VS2005SQLServerExpress. after carefully reading the documentation, we found that SQLServerExpress supports XCOPY deployment. that is to say, as long as the target computer has an SQL program in the past few days, VS 2005 SQL Server Express. check the document carefully and find that SQL Server Express supports XCOPY deployment. that is to say, if the target computer has SQL Server Express, you only need to copy the database, you can configure the AttachDBFileName parameter in the connection string in the same directory of the program. The database is automatically attached to SQL Server Express and automatically Deattch after running. I felt good. as a result, I encountered an error: "The database has been compressed and cannot be created. we need to decompress it ". Dizzy. When will it be compressed? Is it Shinrk? It took n hours to go to bed.
The next day, I tried again. I had no solutions for reading the materials, and I had no solutions for accessing the Internet. I was reluctant to give up. I accidentally found that the Attach database in the management interface was also this error, but the database in the original directory was okay. An error occurs when you copy the database to the program directory (on D: Disk, SQL Server Express is installed on C: disk. That's not the case, right?
After moving the program directory to drive C, everything is normal and then completely dizzy. Is it necessary to automatically mount the database on drive C ???
In addition, if the database file is set to read-only, it can be attached to any disk, but it is only a read-only database.
Although the problem has been solved, but do not understand the principle, is it a Bug, or is it my system problem?
In fact, Sybase's SQL Anywhere is really good. The database management system is started only when the database is started. The system is running and the database management system is automatically stopped, if SQL Server Express also supports this function, I don't like running an SQL Server service when I don't need a database. Access does not support stored procedures. it is not easy for Microsoft to love you.
BLOG: ZhangJinglin


Listen 2005 SQL Server Express. check the document carefully and find that SQL Server Express supports XCOPY deployment, that is, as long as the target computer has SQL...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.