Reposting: How to extract (and email) only 1 client's data from th

Hi,
My vb.net app will use msde for database needs. The app is a tool in which the app user (companyA) will do some planning for their clients. So basically, the database will have information about all the clients (Sam, Julia, Peter, Nancy etc) of our cust
omer (companyA). Now suppose there is some error happening in the application for user Nancy, and we want the companyA to send us only Nancy's data so that we can duplicate the error and debug it. How do we do that...
In previous versions of our app where we used the flat files for data storage, we will just tell the companyA to email us Nancy.ourFile so that we can have a look at the data which is causing the problem. How to extract only Nancy's data from the whole d
atabase...
Thanks
dev
hi,
"dev_kh" <devkh@.discussions.microsoft.com> ha scritto nel messaggio
news:782E4169-30DB-4AEF-B7BC-CC375DABE132@.microsoft.com...
> Hi,
> My vb.net app will use msde for database needs. The app is a tool in
which the app user
>(companyA) will do some planning for their clients. So basically, the
database will have
>information about all the clients (Sam, Julia, Peter, Nancy etc) of our
customer (companyA).
> Now suppose there is some error happening in the application for user
Nancy, and we want
> the companyA to send us only Nancy's data so that we can duplicate the
error and debug it.
> How do we do that...
> In previous versions of our app where we used the flat files for data
storage, we will just tell the
> companyA to email us Nancy.ourFile so that we can have a look at the data
which is causing
>the problem. How to extract only Nancy's data from the whole database...
> Thanks
> dev
>
it depends how you can identify Nancys' data...
if it's a complete database, than detach it, zip it and mail it...
if data is shared with other user's data, than you have to filter on perhaps
owner.tableName.col_User = 'Nancy' and export it to a flat file, probably
using BCP, something like
c:\>BCP "SELECT * FROM [db_name].[owner].[table/view name] WHERE colUser =
'Nancy'" queryout c:\NacyData_objName.txt -c -S(local) -T
make a batch file with all the queryout BCP commands...
or provide a DTS to be executed locally to equally export to file
those file will be then BCP in on testing server for toubleshouting...
good idea? =;-)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Repository of databases

Hello,
I've written a tool that analyzes databases. However, to test it out
really well, I need to feed it a lot of different databases. Is there a
place where I can download either .mdf/.ldf set of files or sql scripts
for various databases? A repository of some kind, perhaps.
Thanks.
Backup database and restore it with a different name
"Frank Rizzo" <nospam@.nospam.com> wrote in message
news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I've written a tool that analyzes databases. However, to test it out
> really well, I need to feed it a lot of different databases. Is there a
> place where I can download either .mdf/.ldf set of files or sql scripts
> for various databases? A repository of some kind, perhaps.
> Thanks.
|||Uri Dimant wrote:
> Backup database and restore it with a different name
I need databases with different schema to really test out the tool.

>
> "Frank Rizzo" <nospam@.nospam.com> wrote in message
> news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
>
>
|||Hi Frank,
For Access sample databases, you could download them here
Access 2000 Tutorial: Northwind Traders Sample Database
http://www.microsoft.com/downloads/d...372-8dbe-422b-
8676-c632d66c529c&DisplayLang=en
For SQL sample databases, you could download them here
Northwind and pubs Sample Databases
http://www.microsoft.com/downloads/d...212-0356-46a0-
8da2-eebc53a68034&DisplayLang=en
You may also search download.microsoft.com with "sample" as key word for
more detailed information.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Repository of databases

Hello,
I've written a tool that analyzes databases. However, to test it out
really well, I need to feed it a lot of different databases. Is there a
place where I can download either .mdf/.ldf set of files or sql scripts
for various databases? A repository of some kind, perhaps.
Thanks.Backup database and restore it with a different name
"Frank Rizzo" <nospam@.nospam.com> wrote in message
news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I've written a tool that analyzes databases. However, to test it out
> really well, I need to feed it a lot of different databases. Is there a
> place where I can download either .mdf/.ldf set of files or sql scripts
> for various databases? A repository of some kind, perhaps.
> Thanks.|||Uri Dimant wrote:
> Backup database and restore it with a different name
I need databases with different schema to really test out the tool.
>
> "Frank Rizzo" <nospam@.nospam.com> wrote in message
> news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
>>Hello,
>>I've written a tool that analyzes databases. However, to test it out
>>really well, I need to feed it a lot of different databases. Is there a
>>place where I can download either .mdf/.ldf set of files or sql scripts
>>for various databases? A repository of some kind, perhaps.
>>Thanks.
>
>|||Hi Frank,
For Access sample databases, you could download them here
Access 2000 Tutorial: Northwind Traders Sample Database
http://www.microsoft.com/downloads/details.aspx?FamilyID=c6661372-8dbe-422b-
8676-c632d66c529c&DisplayLang=en
For SQL sample databases, you could download them here
Northwind and pubs Sample Databases
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-
8da2-eebc53a68034&DisplayLang=en
You may also search download.microsoft.com with "sample" as key word for
more detailed information.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Repository of databases

Hello,
I've written a tool that analyzes databases. However, to test it out
really well, I need to feed it a lot of different databases. Is there a
place where I can download either .mdf/.ldf set of files or sql scripts
for various databases? A repository of some kind, perhaps.
Thanks.Backup database and restore it with a different name
"Frank Rizzo" <nospam@.nospam.com> wrote in message
news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I've written a tool that analyzes databases. However, to test it out
> really well, I need to feed it a lot of different databases. Is there a
> place where I can download either .mdf/.ldf set of files or sql scripts
> for various databases? A repository of some kind, perhaps.
> Thanks.|||Uri Dimant wrote:
> Backup database and restore it with a different name
I need databases with different schema to really test out the tool.

>
> "Frank Rizzo" <nospam@.nospam.com> wrote in message
> news:OdOQoMs2FHA.3052@.TK2MSFTNGP10.phx.gbl...
>
>
>|||Hi Frank,
For Access sample databases, you could download them here
Access 2000 Tutorial: Northwind Traders Sample Database
http://www.microsoft.com/downloads/...1372-8dbe-422b-
8676-c632d66c529c&DisplayLang=en
For SQL sample databases, you could download them here
Northwind and pubs Sample Databases
http://www.microsoft.com/downloads/...6212-0356-46a0-
8da2-eebc53a68034&DisplayLang=en
You may also search download.microsoft.com with "sample" as key word for
more detailed information.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.