Copying a subset from SQL Server

Newbie question: (apologies all)
How does one download a subset from server to notebook?
Practical problem: Executive visiting customer wants database on customer.
Sharepoint and Project 2003 data.
Thank you
Brent Rowell
"Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
> Newbie question: (apologies all)
> How does one download a subset from server to notebook?
> Practical problem: Executive visiting customer wants database on customer.
> Sharepoint and Project 2003 data.
Once you've got MSDE installed on the laptop, you could use Enterprise
Manager and DTS to transfer the data subset you need from the server to the
notebook...
Steve
|||Thank you
Brent
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> "Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
> news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
customer.
> Once you've got MSDE installed on the laptop, you could use Enterprise
> Manager and DTS to transfer the data subset you need from the server to
the
> notebook...
> Steve
>
|||"Brent Rowell" <brent@.pls_remove_jrowell.com> wrote in message news:<eEYV2wPIEHA.3200@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Thank you
> Brent
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> customer.
> the
You could use Super*SQL to create an ASCII file containing all of the
database tables, then copy the file to the notebook and load into the
local database. I found the Beta version at www.sqlmagic.com.