Export Data to SQL File?

Hello,
I'm relatively new to SQL Server -- generally I use Access for my web
projects -- but I'm building a site for a client and they want an SQL
back-end, and I've got my tables built and queried from the ASP pages
just fine.
My question is this: how can I export the data from my SQL Server
database onto the customer's server while retaining the structure and
data. I've seen files with sql extensions that had both the CREATE and
INSERT statements, and I'm wondering if this might be the best method to
use.
I'd like the transfer to be as simple as possible so I won't have to
answer an array of questions about SQL Server that I probably won't be
able to. Any advice?
Thanks!
Jonathan
PS: I already have my copy of SQL Server for Dummies handy. :-p
PPS: Running SQL Server 2000 Personal Edition on a Windows 2000
Professional system.You can backup the database and restore it to their server
or you can detach the data and log file using sp_detach_db
and have them attach the database to their server using
sp_attach_db. You can find more info in books online as well
as in the following articles. You only need to follow the
sections on moving user databases:
Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/?id=224071
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
-Sue
On Wed, 20 Oct 2004 20:24:52 -0400, "Jonathan S."
<spam@.jdspt.com> wrote:

>Hello,
>I'm relatively new to SQL Server -- generally I use Access for my web
>projects -- but I'm building a site for a client and they want an SQL
>back-end, and I've got my tables built and queried from the ASP pages
>just fine.
>My question is this: how can I export the data from my SQL Server
>database onto the customer's server while retaining the structure and
>data. I've seen files with sql extensions that had both the CREATE and
>INSERT statements, and I'm wondering if this might be the best method to
>use.
>I'd like the transfer to be as simple as possible so I won't have to
>answer an array of questions about SQL Server that I probably won't be
>able to. Any advice?
>Thanks!
>Jonathan
>PS: I already have my copy of SQL Server for Dummies handy. :-p
>PPS: Running SQL Server 2000 Personal Edition on a Windows 2000
>Professional system.|||YOu may encounter user/login mismatches in moving the database from one
server to another... Make sure you read the white papers Sue Mentioned
And one of these as well..
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5n7en01brh6gd2d0vekmbpbkgdrv4c12us@.
4ax.com...
> You can backup the database and restore it to their server
> or you can detach the data and log file using sp_detach_db
> and have them attach the database to their server using
> sp_attach_db. You can find more info in books online as well
> as in the following articles. You only need to follow the
> sections on moving user databases:
> Moving SQL Server databases to a new location with
> Detach/Attach
> http://support.microsoft.com/?id=224071
> INF: Moving SQL Server 7.0 Databases to a New Server with
> BACKUP and RESTORE
> http://support.microsoft.com/?id=304692
> -Sue
> On Wed, 20 Oct 2004 20:24:52 -0400, "Jonathan S."
> <spam@.jdspt.com> wrote:
>
>|||Thanks very much for your responses and for the links. I'll definetely
be reading up on this.
I appreciate the help.
Thanks,
Jonathan