how to backup only a few tables?

Heya guys,

I want to pack up a few of the tables in my database to send to a
developer to develop aspx code. I was thinking it would be great to
create a .bak file with just those tables he needs to do the
development. Is there a way to do this? How about an MDF file?

Regards,
Mike

Re: how to backup only a few tables?

mike wrote:
> Heya guys,
>
> I want to pack up a few of the tables in my database to send to a
> developer to develop aspx code. I was thinking it would be great to
> create a .bak file with just those tables he needs to do the
> development. Is there a way to do this? How about an MDF file?
>

What database are you using? Actually, more to the point, in what
format does the dotnet developer prefer to accept the data?

--
Mike Brind

Re: how to backup only a few tables?

Mike Brind wrote:
> mike wrote:
> > Heya guys,
> >
> > I want to pack up a few of the tables in my database to send to a
> > developer to develop aspx code. I was thinking it would be great to
> > create a .bak file with just those tables he needs to do the
> > development. Is there a way to do this? How about an MDF file?
> >
>
> What database are you using? Actually, more to the point, in what
> format does the dotnet developer prefer to accept the data?
>
> --
> Mike Brind

using SQL server 2005. Not sure what the best format is, I want to put
this out for a quote and i dont want to give the whole database away as
its 300 megs. Im thinking a bak or mdf would be good.

Re: how to backup only a few tables?

mike wrote:
> Mike Brind wrote:
>> mike wrote:
>>> Heya guys,
>>>
>>> I want to pack up a few of the tables in my database to send to a
>>> developer to develop aspx code. I was thinking it would be great to
>>> create a .bak file with just those tables he needs to do the
>>> development. Is there a way to do this? How about an MDF file?
>>>
>>
>> What database are you using? Actually, more to the point, in what
>> format does the dotnet developer prefer to accept the data?
>>
>> --
>> Mike Brind
>
> using SQL server 2005. Not sure what the best format is, I want to
> put this out for a quote and i dont want to give the whole database
> away as its 300 megs. Im thinking a bak or mdf would be good.

Just do a DTS (there's an Export wizard in SSMS) to another database and
detach it from your server. Send the file to the developer and he can attach
it to his own server. Look these terms up in Books Online (BOL) or post your
questions to a SQL Server newsgroup for details.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"