Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different ways of moving data/databases
between servers and databases in SQL Server?
- 1 Answers
- 4511 Views
- I also Faced
- E-Mail Answers
Answer / swapna
There are lots of options available, you have to choose
your option depending upon your requirements.
Some of the options you have are: BACKUP/RESTORE,
dettaching and attaching databases, replication, DTS, BCP,
logshipping, INSERT...SELECT, SELECT...INTO, creating
INSERT scripts to generate data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is normalization in Database ?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
what is isolation level at dead lock?
explain how to create a new schema in a database? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the difference between a function and a stored procedure?
How to get @@error and @@rowcount at the same time?
What is the purpose of forms?
Explain about link server in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is sql or structured query language?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
