What are the ways of moving data/databases between servers and databases in SQL Server?

Report
Question

Please briefly explain why you feel this question should be reported .

Report
Cancel

Are their anyways to do so?

in progress 0
Engineering 5 months 1 Answer 87 views Pioneer 0

About YashPioneer

Answer ( 1 )

  1. Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    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.

Leave an answer

Browse

Captcha Click on image to update the captcha .

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>