Answer / pandians

Moving Data :
-------------
1. Configuring Linked Server between servers and move the
data using four part naming convension
i.e: Server.Database.Schema.Table
2. Use Export and Import wizard
3. Using SSIS or DTS Package to move data to different
database or server
4. Use three part naming convension to move data to
different database within the server/instance.
5. Using BCP to move data.

Moving Database:
----------------
1. Detach...Attach
2. Backup and Restore
3. Stop the Service
3.1 Using Alter statement to relocate the database path
3.2 Copy the files into new location
3.3 Start the Service
4. But, Moving system database except Master and Resource
can follow the above way

Answer / santo

export/import...attach/detach...DTS....backup/restore!

Answer / monal

BCP (BULK COPY PROGRAM)

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---