Deployment Disaste

NickTUK · January 5th, 2010, 03:15 PM

Quote:

Originally Posted by Imar

Hard to tell as I don't know what services they offer and at what quality. Not allowing scripts is not uncommon.

How were you able to create the tables? Did you use Management Studio? If so, you can use it to transfer data as well.

Imar

Imar,

They told me the scripts weren't allowed so what I had to do was export the schemas only in sql management studio and then create the tables from those. Following that, I managed to do the same with the data.

Unfortunately, some of the data had <p> <b> and other html, so that didn't. So all I need to do now is add those records back, only a couple of hours work and then all my book reviews and health recipes will be there for the world to enjoy.

You can check the site now, using your book I've managed to configure the connection strings and everything is good to go.

I think if my host had been more clear and offered the advice I needed, then it could have all been sorted a lot quicker.

But yeah. I'm live and you can check me out at www.ntcoding.com. Book reviews and recipes to be added over the next few hours.

Thanks.

Imar · January 5th, 2010, 04:21 PM

Yeah, I noticed it was up and running when I posted my last message. Great to see the site progress each time I check... ;-)

Imar

NickTUK · January 5th, 2010, 06:06 PM

Quote:

Originally Posted by Imar

Yeah, I noticed it was up and running when I posted my last message. Great to see the site progress each time I check... ;-)

Imar

Almost, almost there. I managed to get all my old database entries back by snipping out all the html. So now all I need to do is login to the management section and add them back.

However, that's where I've come unstuck. Once this is sorted, I am fully up and running. Here's the problem:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

I've run aspnet_regsql on the database and re-uploaded all the tables that were originally from the ASPNETDB database. I've then followed the instructions on Appendix B to set up the providers on web.config and to override the LocalSqlServer.

If this something that is really obvious, please can you let me know? In the meantime I'm going to check all the connection string details and providers for typos.

Thanks.

Imar · January 5th, 2010, 06:10 PM

Quote:

If this something that is really obvious, please can you let me know?

The error message says that stored procedures (and Views) for the Application Services (Memberhip, Roles and Profile) are missing. Copying tables is not enough; you also need to copy the many Views and Stored Procedures from the aspnetdb database, either through Management Studio or by using aspnet_regsql as explained in Appendix B (if your hosts allows remote access).

I am still not sure how exactly you're creating your tables, so I can't really recommend the best way to copy these objects.

Imar

NickTUK · January 5th, 2010, 06:30 PM

Quote:

Originally Posted by Imar

The error message says that stored procedures (and Views) for the Application Services (Memberhip, Roles and Profile) are missing. Copying tables is not enough; you also need to copy the many Views and Stored Procedures from the aspnetdb database, either through Management Studio or by using aspnet_regsql as explained in Appendix B (if your hosts allows remote access).

I am still not sure how exactly you're creating your tables, so I can't really recommend the best way to copy these objects.

Imar

Hi Again Imar,

I solved this issue.

When I checked the stored procedures list they weren't actually there. So I did a publish from VWD of the schema only and this worked perfectly. But it also reset my data.

So then I published the data only and that worked fine.

It makes me laugh really. The combined schema and data publish did not work, but individually they do.

Wow. I thought the uploading was going to be the easy bit! But I'm finally there. Thanks for all your help (including the book).

The review of your book and all the other records on my site will be re-formatted with html tags so you can view them as intended if you wish.

Thanks again for all your help.

Imar · January 5th, 2010, 06:36 PM

Are you automatically generating the cover images? This results in some awkward images / reviews as the images are cached. Also, since each review seems to be using the same physical image (http://www.ntcoding.co.uk/Images/Boo...eviewImage.jpg, or so it appaers), concurrent visits will get you in trouble....

Imar

NickTUK · January 5th, 2010, 07:06 PM

Quote:

Originally Posted by Imar

Are you automatically generating the cover images? This results in some awkward images / reviews as the images are cached. Also, since each review seems to be using the same physical image (http://www.ntcoding.co.uk/Images/Boo...eviewImage.jpg, or so it appaers), concurrent visits will get you in trouble....

Imar

Yeah, as the images are read into the individual review page it is resized and saved as BookReviewImage.jpg.

Concurrency wasn't something I anticipated, but I can definitely see the drawbacks with this approach.

I did check all the reviews on my home set up. My plan was to check them out at work on the large screen monitors when I get chance.

The book images I did want to switch for better quality ones before I started showing my site to prospective employers, though.

If you spot anything else then please send the comments this way.

Cheers

Nick

Imar · January 5th, 2010, 07:24 PM

You probably want to save / stream them as:

BookReviewImageReviewId.jpg

instead so each review gets its own image. Because the browser caches this file, you only ever see the image from the first review you view, for all subsequent reviews you visit.

Imar

NickTUK · January 8th, 2010, 08:28 AM

Cross browser and cross monitory compaitibility is proving to be quite fun. But I should be able to resolve all those issues quite soon.

One problem I am facing is sending emails. From local host it works fine, but when the site goes live, I get and error about connections involving a time out.

After a bit of research, it seems to be an authentication/proxy issue. I've got a few articles to read which may yield an answer, but if anyone knows what the problem will be it would save me a bit of time and be appreciated.

thanks

Imar · January 9th, 2010, 07:11 AM

How did you configure the mail server? And did you get the relevant details from your host? Just as with databases, your host should be able to provide you with details about sending mail. They may give you access to a (password potected) mail server, or they may provide other information about how to make this work.

Cheers,

Imar