Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 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 21st, 2007, 10:03 AM
Authorized User
 
Join Date: May 2007
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Script to populate TBH database

Hi,

Did someone please know where to get all the sql script files(Insert, Update,...) that polulate the whole database?

Or better how to generate those file from Visual studio.Net?
I only manage to generate the sql files for creating empty tables.

Many thanks :)

PS: Do you know another software manager that can perfom the database import task other than SQL Server Microsoft Studio Express? I later install the MSSQL Standard Edition on top on Express, but I couldn't manage to activate the SSIS.

 
Old May 23rd, 2007, 10:10 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is a timely question because I have been working with the new SQL Server Database Publication Wizard, and this is exactly what you're looking for. But Marco provided us with a full database in the code download, and that is easy to use. You can also copy the .dbf to another server and attach it there.

But you can't easily populate a remote server in a shared hosting arrangement where you don't control the server. In this case, you have the DBO role in your own database, but you are NOT in the SA group. See my other message here about how to deploy to those servers - the subject of my message will be: "Database Deployment to Shared Servers; SQL Script". That can make you a complete SQL script. At least I think it's complete.

Eric
 
Old May 25th, 2007, 04:42 AM
Authorized User
 
Join Date: May 2007
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you very much,

I also believe that the new SQL Server 2005 Database Publishing Wizard can do the job. I will try it soon :)

Cheers






Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Deployment to Shared Servers; SQL Script englere BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 6 May 17th, 2008 07:00 AM
LINQ to SQL example for TBH - Wrox Blox Errata dparsons BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 April 26th, 2008 09:25 AM
populate Menus from Database harrysingh26 ASP.NET 2.0 Professional 0 February 21st, 2006 02:39 AM
sql script that gets the 2 different database vaneza SQL Server 2000 1 August 3rd, 2005 02:55 AM
sql server database backup by script mateenmohd SQL Server 2000 4 July 6th, 2004 12:32 PM





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