April 16, 2010 at 12:28 pm
These comments are made with the following programs used as tools:
MSFT SQL Server 2008 Express
MSFT SQL Server Management Studio Express 2008 (SSMS)
MSFT Visual Web Developer 2008 (VWD)
My ISP uses a 2005 version of SQL Server.
Can anyone tell me the complete story of how one moves a SQL Server database that works on my computer to an IP's server so the application that works on my computer in localhost then works for viewers of my web site?
There seems to be two different processes. The first one consists of moving the database as a backup file from my computer to the IP server. And then there is a different process when I add tables and queries to the database and want them moved to the IP server.
Apparently both processes involve SSMS.
I am supposed to create, somehow or other, the name of my IP server with my SSMS program. I don't see how I can do this. The only server my SSMS admits exists is my SQLEXPRESS server. And as far as
I can see, it doesn't give me a way to make another server.
I have created an application in VWD that uses a SQL Server database. When I simulate its action on the web with my browser I bring up pages that perform queries with the database. And everything works correctly.
I have used VWD's FTP process to copy the pages and the database over to the IP server. My site viewers can open the first page of the site. As soon as they click on a page where the content involves database content, the system comes up with a stupid comment about I should change 'mode' in my error tag to 'off'. It's already off. The message is worthless.
There is a certain amount of coordination between what the IP server has as the name of my database and what I have in my web.config file. I have a Data Source name which was given me by the IP, an
initial catalog name which is my domain name, my user ID name which apparently can be anything, my password which can be anything and my database name which comes from the database name I have in my VWD App_Data folder.
Those are the fields which, apparently, should be coordinated. And as far as I have been told, the IP has set its corresponding fields to the above values.
THE IP seems to think they have done the right thing, whatever that is, with the backup which I sent them in the private folder of httpdocs. Either plesk, which a lot of IPs use, or MSFT developed this setup of folders.
Here are some questions.
If the IP wants a backup of the database, is there anything more to sending it than to simply FTP it into the private folder, phone the IP so he knows it is there and then having him put it where my web pages will find it?
How do the changes I make in VWD get moved to the IP's server? It is very confusing to me to essentially create the pages with VWD, include a gridview with a query, ftp the page changes to the IP and then have to send the database all over again to the IP with the new tables and new queries in a separate process. That doesn't sound right.
The entire process of moving a database to an IP and changing it as I create more pages is extremely murky.
Can anybody give a complete explanation of the entire process?
April 17, 2010 at 3:50 am
i host my own its a lot easier. Most ISPs charge to host SQL server databases. Its almost definitely the fact the database connection is not correct.
you may want to set the custom errors mode to on whilst attempting to find the issue and switch it off after wards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply