August 13, 2007 at 4:04 am
Hi all DBA's
I want to migrate my 15 GB database from sql server 2000 to sql server 2005
i used many DTS packages and round 50 crystal report for checking the table data. i want to migrate these DTS packages into integration services and
i want all my crystal report 8.5 reports into reporting services
how to achive this task..
if any one have the detailed document then please send me and post in this thread
Thanks & Regards
shashi kant chauhan
August 13, 2007 at 5:30 am
August 13, 2007 at 7:52 am
Sounds like what you want to do is translate from Mandarin to Sanskrit (or should it be the other way around?). There are no magic bullets or global procedures to help you here.
Consider taking this time to reexamine why your crystal reports are built the way they are - you may be able to provide your end-users with more powerful reporting tools in SSRS, rather than simply trying to clone the Crystal reports, and give your clients/users more bang for the buck. Also, they will prefer the results when you finish and appreciate the effort and time it took. Just cloning the Crystal into SSRS won't give them that sense of value.
August 13, 2007 at 9:05 am
If you have to ask for a detailed document, you might not be the person to do this job. It can be complex to migrate a server to a new platform if something goes wrong and if you don't understand what you're doing, you can mess up the system.
The database upgrade should be pretty easy, but you should run the upgrade advisor and check for problems. If you find specific problems, we might be able to help. To move DTS objects, you'll need to understand SSIS or hope the runtime works for you. For Crystal, no idea if they'll run or not. You need a test server for this.
August 14, 2007 at 3:09 am
You are giving yourself a lot of work just to stand still. As people have said, to move from Crystal to SSRS means re-engineering your reports. The same applies for DTS to SSIS. You need to have a good business case to spend this time and money, as both Crystal and DTS will work fine in SQL 2005.
As far as moving from SQL 2000 to SQL 2005 goes, if you send me your email address I can send you copies of our build documentation and scripts.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 14, 2007 at 3:29 am
Of course that rather depends on how your Crystal Reports are written - if they're written by a DBA then chances are they just hook into stored procedures, and the procedures do all the work, therefore it is just a question of pointing your reports to a different location.
If, however, they have been written by Crystal "Professionals" the chances are there are joins and sums in the reports themselves, which makes them extremely difficult to reverse engineer and will take you a lot of time.
As Ed says, though, just pointing to the new database should be enough to retain the existing reports. Regardless, you might be better off looking at 2005 in terms of whether you still need these things, as there may be additional functionality which makes them redundant.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply