Jump to content

Ms Sql Server Technology Discussions


9Pardhu

Recommended Posts

  • 5 months later...

1st ques
please tell me **how to migrate data from excel to sql server 2008r2...!!!

koncham easy process chepandi evaraina.


multiple files/ multiple tyms usage aithe...using SSIS package...

One tym load aithe direct gaa database nundi load cheyyadame... n aftr tht neek kaavali ante aa process ni SSIS pkg laaga kuda save chesukovochu
Link to comment
Share on other sites

multiple files/ multiple tyms usage aithe...using SSIS package...

One tym load aithe direct gaa database nundi load cheyyadame... n aftr tht neek kaavali ante aa process ni SSIS pkg laaga kuda save chesukovochu

 

koncham brief ga chepava bhayya

above 2 ways.

Link to comment
Share on other sites

2nd ques

master and system databases differences enti?

ee database ni ela backup cheyochu?

epudantay apudu restore cheyocha malle?


master db, temp db, msdb, temp db r called systm db s...

master db ante... ne system level info motham andulo record avuthuu untadii... user created db names... locations... login details anni...

ela back up ante... nt sure.. but db meeda right clk chesthe backup option untadi... nvr tried b/c no access...

S... eppudante appudu restore chesukovochu master db ni
Link to comment
Share on other sites

koncham brief ga chepava bhayya
above 2 ways.


eadina pkg meeda wrk chesthu struck ayyavaa r ippudu strtng aa??
SSIS process ki OL lo links untaii...
kaavaali ante oka 1 hr lo vethiki post chrsthaa
Link to comment
Share on other sites

eadina pkg meeda wrk chesthu struck ayyavaa r ippudu strtng aa??
SSIS process ki OL lo links untaii...
kaavaali ante oka 1 hr lo vethiki post chrsthaa

 

ipudu starting

link post cheyi bhayya, nenu check chesta...

Link to comment
Share on other sites

Microsoft® SQL Server® 2008 R2 SP2 - Express Edition

download cheyadaniki trying

 

download koditay, below list vachindi, edi dwnload cheyali ani adugutundi

 

naa system 64bit os

 

edi download cheyalo chepandi alanay difference chepandi useful avudi next time ki..

 

 

SQLEXPR_x86_ENU.exe

110.4 MB
 110.4 MB
 SQLEXPR_x64_ENU.exe

122.4 MB
 122.4 MB
 SQLEXPR32_x86_ENU.exe

97.4 MB
 97.4 MB
 SQLEXPRADV_x64_ENU.exe

1,008.6 MB
 1,008.6 MB
 SQLEXPRADV_x86_ENU.exe

894.1 MB
 894.1 MB
 SQLEXPRWT_x64_ENU.exe

340.5 MB
 340.5 MB
 SQLEXPRWT_x86_ENU.exe

318.4 MB
 318.4 MB
 SQLManagementStudio_x64_ENU.exe

161.0 MB
 161.0 MB
 SQLManagementStudio_x86_ENU.exe
 
 

Link to comment
Share on other sites

Microsoft® SQL Server® 2008 R2 SP2 - Express Edition

download cheyadaniki trying

 

download koditay, below list vachindi, edi dwnload cheyali ani adugutundi

 

naa system 64bit os

 

edi download cheyalo chepandi alanay difference chepandi useful avudi next time ki..

 

 

SQLEXPR_x86_ENU.exe

110.4 MB
 110.4 MB
 SQLEXPR_x64_ENU.exe

122.4 MB
 122.4 MB
 SQLEXPR32_x86_ENU.exe

97.4 MB
 97.4 MB
 SQLEXPRADV_x64_ENU.exe

1,008.6 MB
 1,008.6 MB
 SQLEXPRADV_x86_ENU.exe

894.1 MB
 894.1 MB
 SQLEXPRWT_x64_ENU.exe

340.5 MB
 340.5 MB
 SQLEXPRWT_x86_ENU.exe

318.4 MB
 318.4 MB
 SQLManagementStudio_x64_ENU.exe

161.0 MB
 161.0 MB
 SQLManagementStudio_x86_ENU.exe
 
 

 

express edition lo tools kuda download cheyochaa?

Link to comment
Share on other sites

express edition lo tools kuda download cheyochaa?


nt sure abt DL n installation bayya...
"loveindia" ani genelia pic tho id untadi... athaniki PM cheii.. he will help u whn he have sme tym..
Link to comment
Share on other sites

×
×
  • Create New...