Ms Sql Server Technology Discussions

[chelsea]

[quote name='deals2buy' timestamp='1349367334' post='1302581401']
nee yavva...nenu project join aina kothalo help adigithe okkadu kuda respond avvaledu DB lo..malli peru ki intha mandi unnaru ee tech meeda
[/quote]


hmm avuna ba inka chala mandi vunnari mktr,srivennala abbo pedda list naku sariga teliyadu e thread ni active ga vuchudamu

[Darling999]

[quote name='Lily' timestamp='1349367250' post='1302581392']
you can refer this

[url="http://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/"]http://www.mssqltips...tion-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...o-a-new-server/[/url]
[/quote]
nenu adigindi enti nuvvu cheptunnadi enti, 2005 nundi 2008 ki kaadu issue oka remote server nunchi inkodaaniki

like Server A to Server B

[Darling999]

[quote name='deals2buy' timestamp='1349367334' post='1302581401']
nee yavva...nenu project join aina kothalo help adigithe okkadu kuda respond avvaledu DB lo..malli peru ki intha mandi unnaru ee tech meeda
[/quote]
[img]http://lh3.ggpht.com/-VcKZsiNAKnY/UGD8BycLSkI/AAAAAAAAHaY/qDn4q1ZT2Qg/s150/PK-17.gif [/img]

[deals2buy]

[quote name='chelsea' timestamp='1349367938' post='1302581448']
hmm avuna ba inka chala mandi vunnari mktr,srivennala abbo pedda list naku sariga teliyadu e thread ni active ga vuchudamu
[/quote]

avuna? ya ee thread ni sticky cheyyamandaam
[quote name='DARLING...' timestamp='1349368194' post='1302581460']

[/quote]

[karna11]

[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

[Guest]

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



manam connect ayyevanni remote servers ke gaa using client tools you specify the server/instance name..local aythe localhost

anyway...full backups lekunda migrate cheyalem..analysis services should be done first then the databases

if you want to just upgrade the existing 2005 to 2008, just do inplace upgrade..lot easier

[Robinhood1676]

even i'm working a SQL DBA

[Guest]

[quote name='Robinhood1676' timestamp='1349371508' post='1302581727']
even i'm working a SQL DBA
[/quote]

malla paina adigindaaniki solution kooda cheppu..

[JUJUBI_JULABI]

nenu unna !

[9Pardhu]

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


try cloning.. i think this will give you good results.

[charygaru]

appatlo bhutto ippudu mushraf

DBA unde ippudu D poyindi only BA

[9Pardhu]

[quote name='charygaru' timestamp='1349373315' post='1302581845']
appatlo bhutto ippudu mushraf

DBA unde ippudu D poyindi only BA
[/quote]

malli D group loki randi

[charygaru]

[quote name='9pardhu' timestamp='1349373420' post='1302581856']

malli D group loki randi
[/quote]

naaku telsindi gorantha kaani ikkada regular ga visit ichhiu gnananm kondantha chesukotaaniki try chestha thnaks

[Darling999]

[quote name='charygaru' timestamp='1349373315' post='1302581845']
appatlo bhutto ippudu mushraf

DBA unde ippudu D poyindi only BA
[/quote]

[charygaru]

[quote name='DARLING...' timestamp='1349373564' post='1302581869']

[/quote]

ala naaki em chepudam anukuntunav ?? symbolic ga DBA la undi nenu naaki poyinu ani aa lekapothe BA ga unte naaki pothanu ani aa??