VS.Net Database Projects - learn to use them (Sample chapter included)

My blog has moved.
You can view this post at the following address:
http://www.osherove.com/blog/2004/3/31/vsnet-database-projects-learn-to-use-them-sample-chapter-inc.html
Published Wednesday, March 31, 2004 9:41 AM by RoyOsherove
Filed under: ,

Comments

Wednesday, March 31, 2004 6:38 AM by Greg Pyatt

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Book name? Publisher? Author? Should I have to go looking through the pdf to find this? Didn't they teach you to quote your sources in school? Naughty. No cookie for you.
Wednesday, March 31, 2004 7:36 AM by Ian Griffiths

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Maybe I missed something, but I don't see how you make a create script that reconstructs the data as well as the schema.

I can see how to export the database structure, but there doesn't seem to be any option for exporting data in the create scripts. I only see the "Export Data..." menu option, which (a) is seperate from create scripts and (b) appears only to be available one table at a time.
Wednesday, March 31, 2004 8:46 AM by Darrell

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Ian - you have to export data 1 table at a time because it exports to a file that is then used by the SQL Server bcp utility to import the data. But once you have exported the data, you can create command scripts that will create the database, create the schema, and import the data.
Wednesday, March 31, 2004 2:41 PM by TrackBack

# Thanks a lot, Roy (by yag)

Wednesday, March 31, 2004 8:27 PM by TrackBack

# Thanks a lot, Roy (by yag)

Wednesday, March 31, 2004 11:41 PM by TrackBack

#

Thursday, April 01, 2004 3:07 AM by Jackie Goldstein

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Greg - Since I happen to know the author of that pretty well :-), here is a link to the book on Amazon:

http://tinyurl.com/6bna

Take Care,
Jackie Goldstein
Author of "Database Access with Visual Basic .NET"

Tuesday, May 18, 2004 5:16 AM by yogi

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Hi,
I have a table (with the same name) on 2 different machines.
lets call the machines:
1) machineToOverwrite
2) machineToBeOverwritten

So, I want to OVERWRITE thae table on machineToBeOverwritten, with the table contained in machineToOverwrite.

I right-click my table --> export data --> OK
The table.dat file appears in the system explorer, in the "CreateScripts" folder.

I am unable to add this .dat file to a command file.
How do I overwrite the table on machineToBeOverwritten with this .dat file?
Do I have to manually write a bcp script, or does vis studio do this for me?
I'm on vis studio 2003 Enterrprise.

Many thanks.
yogi
Tuesday, May 18, 2004 10:47 AM by yogi

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Hi,
Got it.It was staring me in the face.

yogi
Tuesday, October 03, 2006 12:34 AM by Josh

# re: VS.Net Database Projects - learn to use them (Sample chapter included)

Do you have any idea how this can be done in VS2005?