What are the different ways of moving data/databases
between servers and databases in SQL Server?
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 value could be assigned to Varchar Type?
What is database replication? What are the different types of replication you can set up in sql server?
What is Index Segmentation ?
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
What is difference between commit and rollback when used in transactions?
What are the different types of join?
What is a heap?
What are basics of policy management?
What are the different types of collation sensitivity in sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How do you make a trace?
Is SET a SQL Keyword?