i have sql express database and i use manager studio to convert it to bat file then used the tool in the control panel in win host and lets say its succesfull i supposed it takes 2-3 minites for the files to come to app_data i use fillezilla does it show mystore.mdf after this on app_data folder in the server? now my code in web.config looks like this <add name="mystoreEntities" connectionString="metadata=res://*/Models.computerstore.csdl|res://*/Models.computerstore.ssdl|res://*/Models.computerstore.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mystore.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" /> how to i change it to reflect sql servel 2008 thanks
We don't support SQL Express on our shared hosting environment. Try looking at this kb article. http://support.Winhost.com/KB/a622/do-you-support-ms-sql-express-databases.aspx You'll need to run a backup of your local database on your personal computer which in turn will give you a .bak file. Then you wil need to use the Restore/Backup tool in the Winhost control panel Site Manager/MS SQL 2008 Manager to restore the database to our SQL server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx Once you have restored the database to our SQL server you will need to update the connection string on your web application to point to our SQL 2008 server.