Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4.5 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4.5: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-31180-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 14th, 2014, 06:31 PM
Authorized User
Points: 416, Level: 7
Points: 416, Level: 7 Points: 416, Level: 7 Points: 416, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 84
Thanks: 29
Thanked 2 Times in 2 Posts
Default Ch 19 Re-creating the Database

Hi Imar,

My hosting provider uses a service called Plesk developed by Parallels in case that will prompt any special comments from you. There is a page on the hosting control panel to create databases and they allow SSMS to connect to their 2012 SQL Server (SP1).

I created the script from the Export Database Try-It-Out and now need to connect to the SQL server so I can re-create the database at the hosting provider.

I have: (1) the IP address of the server, (2) created an SQL Server database at the server called PlanetWrox, (3) a User Name and Password to access the database.

I'm still learning SSMS. I didn't intuitively see how to connect to the hosting provider SQL server from my desktop. If I missed that in the book please point to it, or is that simple enough for you to relate in this forum? I saw some tutorials at Microsoft for SSMS, but I was hoping you might have a few quick steps to follow to establish the connection.

If I understood things from your book and App B, I simply need to (1) connect to the hosting SQL server, (2) run the script we prepared, (3) change the 2 connections strings in web.config (plus the rest of your deployment checklist) and (4) reload the site to the server. Then the database should work, yes?

Thanks.

Best Regards,
Alan
  #2 (permalink)  
Old February 15th, 2014, 10:27 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Alan,

Take a look at Figure 12-3 on page 425. It shows the Login box for SQL Server. Change Windows Authentication to SQL Authentication (or whatever it's called) in the drop down list and enter your details. You should enter your IP as the server name.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #3 (permalink)  
Old February 16th, 2014, 12:36 PM
Authorized User
Points: 416, Level: 7
Points: 416, Level: 7 Points: 416, Level: 7 Points: 416, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 84
Thanks: 29
Thanked 2 Times in 2 Posts
Default

Hi Imar,

That was perfect. I didn't quite understand that I could type in an IP address to reach the server. So,

1) I logged in, saw the tremendous list of everyone else's databases on that server, and found my PlanetWrox database.

2) I loaded my .sql script created according to the Ch 19 'Exporting' Try-It-Out.

3) But before I clicked execute, I reviewed the script a little. The first line is 'CREATE DATABASE [PlanetWrox]... . In order to gain access to the server I had to create the database called PlanetWrox, so it already exists. Do I need to alter the script, or will it just bypass this command if it sees the database already exists?

Or, should I delete everything on the server, recreate another 'temp' database, and then run the full script and expect the server to allow me to create the PlanetWrox database from within the Server to SSMS interface?

Thanks.

Best Regards,
Alan
  #4 (permalink)  
Old February 16th, 2014, 01:43 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You can use delete the code that creates the database, and then run the script against your existing database.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 19 Bundling and Minification AlanWheeler BOOK: Beginning ASP.NET 4.5 : in C# and VB 7 August 9th, 2016 12:18 PM
Ch. 19 and Appendix B MStarks BOOK: Beginning ASP.NET 4 : in C# and VB 6 November 20th, 2013 06:47 PM
Ch 19 not working either... resolutions BOOK: Beginning JavaServer Pages 6 May 17th, 2007 04:36 AM
Page 975; Ch 19 Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 0 July 31st, 2006 12:25 AM
Page 973; Ch 19 Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 0 July 31st, 2006 12:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.