What should we do to copy the tables, schema and views from
one SQL Server to another?

Answer Posted / guest

We have to write some DTS packages for it.
Copy Database wizard is one of the option to copy a
Database to another Database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to access the deleted record of an event?

758


What is a bit datatype?

750


What is a transactions?

789


What number aggregate functions are accessible there in sql?

785


Explain how would you store your query in an SSRS report or a Database server?

104


What are the different types of collation sensitivity?

768


Explain different types of lock modes in sql server 2000?

702


What is inline table-value user-defined function?

785


what are isolation levels? : Sql server database administration

670


What is a group function explain with an example?

729


How to set the current database in ms sql server?

742


Is BCNF better than 2NF & 3NF? Why?

815


Define magic tables in sql server?

769


What does ss stand for sexually?

802


can an order by clause be used in a creation of a view?

893