What are the different ways of moving data between databases in SQL Server

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET > SQL

What are the different ways of moving data between databases in SQL Server?

✍: Guest

There are lots of option available; you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, detaching and attaching databases, replication, DTS, BCP, logshipping, INSERT...SELECT, SELECT...INTO, creating INSERT scripts to generate data.

2007-10-25, 4855👍, 0💬

How can you raise custom errors from stored procedure
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement c... 2007-10-25, 6809👍, 0💬

What are different types of locks in SQL SERVER
What are different transaction levels in SQL SERVER? Transaction Isolation level decides how is one process isolated from other process.Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER READ COMMITTED The shared lock is held for the dur... 2007-10-25, 6292👍, 0💬

What is ACID fundamental? What are transactions in SQL SERVER
What is ACID fundamental? What are transactions in SQL SERVER ? A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a t... 2007-10-25, 5568👍, 0💬

What are the different locks in SQL SERVER
What are the different locks in SQL SERVER ? Depending on the transaction level six types of lock can be acquired on data Intent The intent lock shows the future intention of SQL Server's lock manager to acquire locks on a specific unit of data for a particular transaction. SQL Server uses intent lo... 2007-10-25, 5462👍, 0💬

Can we suggest locking hints to SQL SERVER
Can we suggest locking hints to SQL SERVER ? We can give locking hints that helps you over ride default decision made by SQL Server. For instance, you can specify the ROWLOCK hint with your UPDATE statement to convince SQL Server to lock each row affected by that data modification. Whether it's prud... 2007-10-25, 5291👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 5135👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 5134👍, 0💬

What are advantages of SQL 2000 over SQl 7.0
What are advantages of SQL 2000 over SQl 7.0 ? User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local... 2007-10-25, 5104👍, 0💬

What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table, while UNION ALL selects all records from both the tables. Note : Selected records should have same datatype or els... 2007-10-25, 5077👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.