Jump to content

Ms Sql Server Technology Discussions


9Pardhu

Recommended Posts

naa daggara rendu remote servers unayi

1st one have SQL 2005 and 2nd one have sql 2008

Now I want to migrate all the Database stuff like Database with data, Integration server Packages, SSAS CUbes and SSRS reports from 1st server 2005 SQL to 2nd one SQL 2008. What is the best way I can do this migration without any major issues like data discrepancy and Stuff?

Evarainaa chesaara ippatidaaka ila??

Link to comment
Share on other sites

[quote name='DARLING...' timestamp='1349366458' post='1302581341']
naa daggara rendu remote servers unayi

1st one have SQL 2005 and 2nd one have sql 2008

Now I want to migrate all the Database stuff like Database with data, Integration server Packages, SSAS CUbes and SSRS reports from 1st server 2005 SQL to 2nd one SQL 2008. What is the best way I can do this migration without any major issues like data discrepancy and Stuff?

Evarainaa chesaara ippatidaaka ila??
[/quote]

Help

Link to comment
Share on other sites

[quote name='dubbak' timestamp='1349366700' post='1302581356']
Databases nenu chesaanu...
Just take a Full backup and restore it on SQL 2008 box.

I dnno about other.
[/quote]

verey servers lo unayi , 80gb DB ni copy cheyyalemu

Link to comment
Share on other sites

[quote name='DARLING...' timestamp='1349366458' post='1302581341']
naa daggara rendu remote servers unayi

1st one have SQL 2005 and 2nd one have sql 2008

Now I want to migrate all the Database stuff like Database with data, Integration server Packages, SSAS CUbes and SSRS reports from 1st server 2005 SQL to 2nd one SQL 2008. What is the best way I can do this migration without any major issues like data discrepancy and Stuff?

Evarainaa chesaara ippatidaaka ila??
[/quote]

you can refer this

[url="http://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/"]http://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/[/url]

for migrating 2005 reporting services to 2008

[url="http://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/"]http://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/[/url]

Link to comment
Share on other sites

nee yavva...nenu project join aina kothalo help adigithe okkadu kuda respond avvaledu DB lo..malli peru ki intha mandi unnaru ee tech meeda };_

Link to comment
Share on other sites

×
×
  • Create New...