Customer specific data backup (conditional backup)

We are planning to serve a web application on the Internet that customers will be signing up for, to use it.

The application is using SQL server database to store customer data. Same database and same tables will be used for all customers. Tables that store customer data (not system data such as country codes etc) will have a column, say, CustomerID that will indicate the record belongs to that customer.

Now we are looking for some sort of tool to allow us to backup a single customer's data and give it to them in case they ask for their data. For example, if Customer with CustomerID = 445 wants his data, we should be able to create a sql database that contains all records from all tables that have a customerID column, where the customerID = 445. If a table does not have customerID column we want to include all rows from such table.

I was wondering if such a tool (MS or third party) exists, or shall we create our own?

I appreciate your response.

You would create an SSIS package to do something like this.

Custom Data Extensions and Custom Code: do they require any special settings for internet?

I have configured the config files so that my custom code and data extension
work fine internally. I am having problems getting them to work over the
internet.
Are there any special considerations for this?
ThanksWhat kind of problems?
What do you mean by "work over the internet"?
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Kevin" <k@.r.com> wrote in message
news:uCmWs0kCFHA.2632@.TK2MSFTNGP09.phx.gbl...
> I have configured the config files so that my custom code and data
extension
> work fine internally. I am having problems getting them to work over the
> internet.
> Are there any special considerations for this?
> Thanks
>|||I have solved the issue. Code Access had to be set for the custom dll.
Thanks
"Alexandre Mineev [MSFT]" <almineev@.microsoft.com> wrote in message
news:eXrtP9tDFHA.392@.TK2MSFTNGP14.phx.gbl...
> What kind of problems?
> What do you mean by "work over the internet"?
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Kevin" <k@.r.com> wrote in message
> news:uCmWs0kCFHA.2632@.TK2MSFTNGP09.phx.gbl...
>> I have configured the config files so that my custom code and data
> extension
>> work fine internally. I am having problems getting them to work over the
>> internet.
>> Are there any special considerations for this?
>> Thanks
>>
>

Custom authentication support in RS 2000

Hi,
I read somewhere that only Integrated Windows Authentication is
supported in RS 2000. Out Web application has internet users, so I
cannot use IW authentication.
Is there any way to use custom authentication (form based)?
Without this we cannot use RS in our application.
Please help.
regards,
Sachin.Hi Sachin,
I don´t know if there´s a way to use form based authentication in rs - I
don´t believe so.
A possible workaround:
run the rs-web under a useraccount who may use rs (but then you can´t differ
between the internet-users) and build your own web-frontend in front of the
rs-web where users only see their reports... a lot of action but full
control.
hth, Tony
"sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
> Hi,
> I read somewhere that only Integrated Windows Authentication is
> supported in RS 2000. Out Web application has internet users, so I
> cannot use IW authentication.
> Is there any way to use custom authentication (form based)?
> Without this we cannot use RS in our application.
> Please help.
> regards,
> Sachin.
>|||Yeah there is. There are several articles on how to do so. And samples
that come with RS2000 and 2005.
However, Custom (forms) authentiation only works in Developer Edition and
Enterprise Edition of 2000, it works with standard in 2005.
"Toni Pohl" <atwork43@.hotmail.com__nospam> wrote in message
news:uTVRWk0TGHA.5884@.TK2MSFTNGP14.phx.gbl...
> Hi Sachin,
> I don´t know if there´s a way to use form based authentication in rs - I
> don´t believe so.
> A possible workaround:
> run the rs-web under a useraccount who may use rs (but then you can´t
> differ between the internet-users) and build your own web-frontend in
> front of the rs-web where users only see their reports... a lot of action
> but full control.
> hth, Tony
> "sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
> news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
>> Hi,
>> I read somewhere that only Integrated Windows Authentication is
>> supported in RS 2000. Out Web application has internet users, so I
>> cannot use IW authentication.
>> Is there any way to use custom authentication (form based)?
>> Without this we cannot use RS in our application.
>> Please help.
>> regards,
>> Sachin.
>|||Using Forms Authentication in Reporting Services.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Sadly, as was mentioned, it needs Developer or Enterprise Edition in RS
2000.
"Chris Taylor" <ctaylor7480@.newsgroups.nospam> wrote in message
news:%23Do3Wu2TGHA.4792@.TK2MSFTNGP14.phx.gbl...
> Yeah there is. There are several articles on how to do so. And samples
> that come with RS2000 and 2005.
> However, Custom (forms) authentiation only works in Developer Edition and
> Enterprise Edition of 2000, it works with standard in 2005.
> "Toni Pohl" <atwork43@.hotmail.com__nospam> wrote in message
> news:uTVRWk0TGHA.5884@.TK2MSFTNGP14.phx.gbl...
>> Hi Sachin,
>> I don´t know if there´s a way to use form based authentication in rs - I
>> don´t believe so.
>> A possible workaround:
>> run the rs-web under a useraccount who may use rs (but then you can´t
>> differ between the internet-users) and build your own web-frontend in
>> front of the rs-web where users only see their reports... a lot of action
>> but full control.
>> hth, Tony
>> "sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
>> news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
>> Hi,
>> I read somewhere that only Integrated Windows Authentication is
>> supported in RS 2000. Out Web application has internet users, so I
>> cannot use IW authentication.
>> Is there any way to use custom authentication (form based)?
>> Without this we cannot use RS in our application.
>> Please help.
>> regards,
>> Sachin.
>>
>