Ms Sql Server Technology Discussions

[9Pardhu]

SQL Server Technology vallu entamandi vunaru?
work lo emina doubts vunte disuss chedam ani...

[chelsea]

SQL BI developer

[Josh]

Ya bhai seypu.....parichayam penchukundham

[9Pardhu]

nenu currently working as SQL Server DBA

[padmasri123]

Iam not SQL developer but have some knowledge in SQL..Iam from oracle background

[karna11]

nenu kodaaa, nenu chesidhi .Net , but SQL developer is passion

[dubbak]

[color=#282828][font=helvetica, arial, sans-serif]nenu kada working as SQL Server DBA[/font][/color]

[Darling999]

[Darling999]

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??

[chelsea]

[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

[dubbak]

Databases nenu chesaanu...
Just take a Full backup and restore it on SQL 2008 box.

I dnno about other.

[Darling999]

[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

[deals2buy]

nenu bhi SQL Server ye

[andhrausa]

[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]

[deals2buy]

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