Showing posts with label steps. Show all posts
Showing posts with label steps. Show all posts

Monday, March 19, 2012

Data Processing Extension in SSRS05

Hi,

I'm trying to deploy my assembly (work fine in Report Manager) into Report Server, but I can't.

I followed the steps in help to deploy, but didn't work. When I run my report, show-me: "An attempt has been made to use a data extension 'GF' that is not registered for this report server". If I go to "New Data Source", my extension don't appear in "Connection Type".

Thanks,

Cristiano Leite

Did you verify that the data extensions works successfully in report designer (see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_extend_dataproc_9cds.asp)?

If it works in report designer, make sure to follow the steps for the server deployment, described in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_extend_dataproc_1fn5.asp

-- Robert

|||

Thanks Robert.

I found the error. I'm using a LogEvent class who is found in report designer, but isn't trusted into Report Server.

I commented this code end work fine.

Thanks

Cristiano Leite.

Saturday, February 25, 2012

data migration from sql server 2000 to 7.0

Hi ,
I want to transfer the data from SQL server 2000 to a SQL server 7.0
Can anyone help me in providing the steps I need to follow..
Thanks in advanceHow much data, how often, how much time allowed?

Easiest way which is still low impact probably is to produce a staging table on the 2000 server with an identity and the data that has to be transferred.
The v7 server has an identical table but with an int for the ID field.
Thev7 calls a stored proc on 2000 with its last ID via a linked server or remote server (could even use replication for this but I wouldn't advise it). This sp returns the next 500 say (recs) which the v7 server inserts into its staging table.
The v7 server can then do whatever it wishes with the data (may have a status field on the recs to say they have been processed.

This has very little impact on the 2000 server as it's production processes just have to get data into the staging table - doesn't matter if the v7 server is down.
If the v7 server has to be restored then it will automatically recover the data from the v2000 server. You will have to cater for the 2000 server being restored though.

Data Migration

Hi
We are in the process of migrating Data from SQL SERVER 2000 to
Oracle 9i.

Can anyone let me know what are the steps that needs to be followed
in achieving the same.

If there's any specific documentation also available , please let me know
Any pointers would be of great help.

Thanks
Shankar GokuleI think you'd get a more sympathetic ear over here:

http://www.dbforums.com/f4/

Besides...migration is migrattion...

Copy structure (in ERWin is nice), forward engineer (change the code to match the platform)...dump data, load to stage, audit data, load new structure...