Quote:
|
Originally Posted by plankton Looks like your hypothesis is probably correct,
does M$ provide a wizard to migrate all the info including the database ? When you say you upload all the files by ftp does this include the database files ?
what tools has your host got for managing SQL server ?, if you have access via Enterprise Manager then you could take the existing database off line , back it up , ftp it to the host and reload it from the backup that would get the data in the right place.
(They must have something that allows you to do that kind of functionality) You would then have to ensure that the username/pw that the web app is using to talk to the server had access to that instance of sql server.
Given its m$ there is probably a wizzard to do just that. or has your host got a help/suport page
hope that helps point you in a useful direction |
Thanks Plankton.
I'm still stuck with this problem, but your musings do go along with what I've been turning up in my investigations.
I think the basic problem comes down to the fact that I'm running MS SQL Server Express on my PC, but am trying to publish my website on a web host that has provided me with a MS SQL Server 2005 Database.
I think I need to work out how get the data from my local MS SQL Express database into the remote MS SQL Server 2005, and then alter my web.config file / application provider settings to point at that 2005 server instance.
I'll keep working on this, but if you or anyone else has already done this then I'd love to hear from you.
Cheers,
Will