Hi, I have vwd website on my home machine and I need to find hosting.
My first Q is: Is there any difference between the file structure of an SQL Server 2005 Express database file and the file structure of a full version SQL Server 2005 database file
Most of the hosters say they will not host Express. I can't tell whether they are referring to the server software or the file itself I know that they host SQL 2005 databases. And I think the two files types are identical, but I am not sure.
My next question is about updating my database after I get it hosted. On my home computer I am adding records and editing records every day, but I only need to update the hosted database about once a week. I think I can just delete the hosted database and install a new copy of my home database once a week. But maybe there is a way to syncronize the two databases. So that is my Question. What are my options for keeping my hosted site updated, and what tools are needed, etc
Thank for any help I can get on this.
vwd 2005 with sql 2005 express database.
Omar Khorshid
1/ No the mdf and ldf files are the same for all versions of SQL Server, including the 64 bit editions.
2/ When hosters say they will not host express they usually mean they will not host the express service in a shared hosting environment, they can and do host the data.
3/ There is no easy way to do this today although a solution is being worked on, if there is no unique data in the hosted database then yes blowing it away and replacing it is a simple option.