Hey - so I have all the files for an existing umbraco site and I am moving it to my server.
First I made an install of umbraco, then I overwrote all the files with the ones I had locally.
Next I tried to import the database, but it times out (its only 30meg!!)
I contacted my host and they said to "Connect to MS. SQL remotely and run the script from your local pc" - which I have no idea about :(
But I tried to install umbraco locally using the guide and I have been successful up to a point, but I cannot create a database, so cannot connect to that database
How do I do this locally? And I suppose is this the correct method to "Connect to MS. SQL remotely and run the script from your local pc"
If you're having problems with restoring the database on your host then you can always try generating the SQL scripts and running them on the target database. Here's the MSDN on how to generate scripts: http://msdn.microsoft.com/en-us/library/ms178078.aspx
For getting your files you should just copy what's on staging environment onto the live environment and change the connection string.
How to move/install existing umbraco site
Hey - so I have all the files for an existing umbraco site and I am moving it to my server.
First I made an install of umbraco, then I overwrote all the files with the ones I had locally.
Next I tried to import the database, but it times out (its only 30meg!!)
I contacted my host and they said to "Connect to MS. SQL remotely and run the script from your local pc" - which I have no idea about :(
But I tried to install umbraco locally using the guide and I have been successful up to a point, but I cannot create a database, so cannot connect to that database
How do I do this locally? And I suppose is this the correct method to "Connect to MS. SQL remotely and run the script from your local pc"
Cheers - ASP/windows/umbraco newbie dummy :)
If you're having problems with restoring the database on your host then you can always try generating the SQL scripts and running them on the target database. Here's the MSDN on how to generate scripts: http://msdn.microsoft.com/en-us/library/ms178078.aspx
For getting your files you should just copy what's on staging environment onto the live environment and change the connection string.
Thanks Slace - I actually needed a client to access the database remotely - I got one and all is good :)
is working on a reply...