Quote:
|
Originally Posted by Will 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. |
Normally you'd backup the local database, FTP the backup file to the server, and then use the appropriate management tool on the server to restore the backup.
Since presumably you don't have remote access to the server's desktop (which is how I do exactly this process with my company's server), you'll need to connect to the remote database with the management app running locally, and use it to restore the local backup file.
If this doesn't make sense, or if you don't have the tools, drop me a PM. I might still be able to help..