Showing posts with label scenarioi. Show all posts
Showing posts with label scenarioi. Show all posts

Wednesday, March 21, 2012

Interesting Problem/Bug with Logos in the page header

Scenario:

I have a report with a logo in the page header.

This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail.

When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X)

If I export the report like this, the red X is rendered in the export. The logo is not there.

Has anyone else experienced this issue?

Anyone know how to resolve it?

Thanks!

BobP

This is a known bug. The fix will be included in the next release.

Monday, March 12, 2012

Interaction between tables of local and remote SQL databases

Hi all,

I would be very glad if someone can suggest me what techniques I should use in the following scenario:

I have 2 SQL Server databases : DB1 and DB2. DB 1 is on a remote server (hosting server) and DB 2 is on a local server.

Some tables of each db contain tables that are polulated and changed by the appropriate application, i.e.:

DB1.users, DB1.orders,... etc are managed by "webapplication"

DB1.products ... are not managed by "webapplication" : in fact only used to read from

DB2.products, DB2.customers, .... etc are managed by "winapplication"

DB2.orders,....are partially managed by "winapplication"

Since the amount of data can go over 100000 records i'm wondering what would by the best approach to :

- synchronize the data of DB1.products and DB2.products in DB1 on remote server (updated newly added rows and update changed rows,....)

- the products data is only (at the moment) added, edited and deleted on the local server

I think SQLBulkCopy will not do the job. Should it be possible with some query? Or...?

Any suggestions are appreciated!!

O.

Some addition:

- Does SQLBulkCopy copy-append data to the destination database.table?

- What about identity keys?

- Should it be the best solution to modify the SqlCommand so it takes only those rows I want to be inserted as (depending on bulkcopies already done before) or is this done by SQLBulkcopy itself....?

Please inform.

O.