Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution 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
 
Old May 7th, 2005, 08:38 AM
Authorized User
 
Join Date: Jun 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default getting the database from the backup file

Hello all!
I'm using Microsoft SQL Express with SQL Express Manager as my core database server for the project.
I have downloaded the code that goes with this Wrox book, but the database included is a backup version (.BAK file). I don't know how to open this database in SQL Express Manager.
Can anybody help me please, so I can continue with the project?
Many thanks
Ben

 
Old May 7th, 2005, 08:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The database comes in 2 formats: one is a SQL 2000 backup, and the other is a SQL 7 backup. There's also a script, but that wasn't updated after the book was published, so I wouldn't use the SQL script.

Do some google searching to learn how to restore a database backup. If it's not in the menus of SQL Express (the Manager is the new GUI tool that replaces Enterprise Manager and Query Analyzer), then you can use SQL commands to do it.

But, SQL Express is a beta of SQL Server 2005, and this database backup was never certified to be compatible with this version. I think it will work, but I can't offer you much support for it.

If you're using the beta version of Visual Studio 2005, or the new Web Developer GUI, the same advice applies: it should work but there are no guarantees.

Eric
 
Old May 8th, 2005, 05:15 AM
Authorized User
 
Join Date: Jun 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Eric,
I followed your advice and found a script to restore the database on this very site:

http://p2p.wrox.com/topic.asp?whichp...ID=28816#67070

I don't understand a word of it but I made some educated guesses and managed to adapt it to my purposes. For everyone's information, it seemed to work just fine, I can see a list of all the tables and queries mentioned in the book now. No compatibility issues.

My biggest surprise was finding out exactly how little I can do with Sql Express Manager. Am I missing something, or do I have to perform everything by typing commands into the query analyser? It won't even let me copy and paste tables! Anybody know where I can learn to do this efficiently? Anybody know if there's an easier option available to me?

 
Old May 8th, 2005, 11:11 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Keep in mind that you are using the Express version - which is the 2005 free version. Compare the SQL Manager with the graphical tools that came with MSDE (the free version of SQL 2000) - MSDE had zero free graphical tools! Even a little bit is a big improvement.

Also, this is still a beta. The final release should be better.

I know that the final relase of the full SQL 2005 product (not the express version) is supposed to have a very nice SQL Manager that is better than anything SQL 2000 had. It's also going to be a bit like Visual Studio, and VS 2005 will have better connectivity to both Oracle and SQL Server.

Eric
 
Old May 12th, 2005, 11:32 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you using the April CTP version of SQL Express with this manager GUI:
http://www.microsoft.com/downloads/d...displaylang=en
 
Old June 10th, 2005, 01:47 PM
Registered User
 
Join Date: Jun 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I didn't seem to get the SQL 7 backup in my download. Is it still available?

When I tried to restore the database I got an error message stating it was the wrong version.


Quote:
quote:Originally posted by englere
 The database comes in 2 formats: one is a SQL 2000 backup, and the other is a SQL 7 backup. There's also a script, but that wasn't updated after the book was published, so I wouldn't use the SQL script.

Do some google searching to learn how to restore a database backup. If it's not in the menus of SQL Express (the Manager is the new GUI tool that replaces Enterprise Manager and Query Analyzer), then you can use SQL commands to do it.

But, SQL Express is a beta of SQL Server 2005, and this database backup was never certified to be compatible with this version. I think it will work, but I can't offer you much support for it.

If you're using the beta version of Visual Studio 2005, or the new Web Developer GUI, the same advice applies: it should work but there are no guarantees.

Eric
 
Old June 12th, 2005, 10:50 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please look for it carefully. The SQL 7 backup file is named differently from the SQL 2K file. I don't remember the filename but I think you can find it. You may have to get the code download for the C# version to find it.

I'm not sure it's wise to use SQL 7 now that SQL 2005 is almost out. Even SQL 2000 is getting pretty old now. But SQL 7 should work fine if you insist on using it. There's nothing in this application that requires newer features than those in SQL 7.





Similar Threads
Thread Thread Starter Forum Replies Last Post
backup of database MunishBhatia SQL Server 2005 0 October 5th, 2007 04:20 AM
Backup of Database (C#) meljab BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 March 31st, 2007 11:45 AM
Backup Database gaurav_jain2403 SQL Server 2000 0 August 3rd, 2006 12:57 AM
The database backup file Malnad BOOK: ASP.NET Website Programming Problem-Design-Solution 0 January 10th, 2006 12:19 AM
Database Backup prakash.wadkar ADO.NET 1 February 22nd, 2005 01:06 PM





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