Groups | Blog | Home
all groups > sql server new users > january 2006 >

sql server new users : SQL Server Developer's Edition


James_101
1/23/2006 9:31:03 AM
I design computer-based training that stores user scores in a database. The
training software sends the data to ASP pages that send the data on to the
database. Because of a large client, I am using SQL Server rather than
Microsoft Access for the db.

I have designed and tested the db using the Developer's Edition for SQL
Server 2000. Now, I need to send the database to my customer who will
install it on a db server which uses SQL Server. What files should I send to
the customer?

Jens
1/23/2006 10:23:46 AM
Hi James,

You can create a backup and send him the backup file to restore the
database OR you can detach the database and send him the MDF/NDF/LDF
files which belong to the database.

HTH, Jens Suessmeyer.
Sue Hoegemeier
1/23/2006 11:21:37 AM
Take a backup of the database and send it to the client.
They can then restore the database to their system.
Or you can detach the database with sp_detach_db and copy
the mdf (and optionally the ldf) to send to the customer.
They can then attach the file(s).

-Sue

On Mon, 23 Jan 2006 09:31:03 -0800, James_101
[quoted text, click to view]
James_101
1/24/2006 11:10:02 AM
Thanks for the help, Sue and Jens.

James

[quoted text, click to view]
Louis Davidson
1/25/2006 10:21:26 PM
Another possibility is to send SQL Scripts. For the first installation this
is not the easiest, but as you start to make changes to the database (which
you will probably have to do since no one is perfect (hopefully a certain Mr
Celko isn't listening :) ) you will have to do this going forward so as not
to kill their data when you make changes. If you have no bugs whatsoever,
you will have to make changes because they will love you so much they will
want more out of you :) Then they create the database, and they run the
scripts (you should probably have the scripts loaded by a CMD file that
launches OSQL or SQLCMD for them, unless they are DB savvy and want to run
their own scripts)

--
----------------------------------------------------------------------------
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)

[quoted text, click to view]

AddThis Social Bookmark Button