9Pardhu Posted October 4, 2012 Report Posted October 4, 2012 SQL Server Technology vallu entamandi vunaru? work lo emina doubts vunte disuss chedam ani...
9Pardhu Posted October 4, 2012 Author Report Posted October 4, 2012 nenu currently working as SQL Server DBA
padmasri123 Posted October 4, 2012 Report Posted October 4, 2012 Iam not SQL developer but have some knowledge in SQL..Iam from oracle background
karna11 Posted October 4, 2012 Report Posted October 4, 2012 nenu kodaaa, nenu chesidhi .Net , but SQL developer is passion
dubbak Posted October 4, 2012 Report Posted October 4, 2012 [color=#282828][font=helvetica, arial, sans-serif]nenu kada working as SQL Server DBA[/font][/color]
Darling999 Posted October 4, 2012 Report Posted October 4, 2012 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 Posted October 4, 2012 Report Posted October 4, 2012 [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 Posted October 4, 2012 Report Posted October 4, 2012 Databases nenu chesaanu... Just take a Full backup and restore it on SQL 2008 box. I dnno about other.
Darling999 Posted October 4, 2012 Report Posted October 4, 2012 [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
andhrausa Posted October 4, 2012 Report Posted October 4, 2012 [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 Posted October 4, 2012 Report Posted October 4, 2012 nee yavva...nenu project join aina kothalo help adigithe okkadu kuda respond avvaledu DB lo..malli peru ki intha mandi unnaru ee tech meeda
Recommended Posts