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

Answer Posted / kmbkrishnan

Copy Database wizard is one of the option to copy a
Database to another Database.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which sql server table is used to hold the stored procedure scripts?

842


What is the difference between TRUNCATE and DROP?

837


Why use cursor in sql server?

788


What do you do in data exploration

745


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1146


What language is sql server written in?

756


What is the need for indexing?

698


How to create a view with data from multiple tables?

806


How would you choose between a clustered and a non-clustered index?

759


What is server-level principal?

114


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1451


What is the difference between a function and a trigger?

799


What is the difference between substr and charindex in the sql server?

721


How do you implement session management in SQL Server mode?

764


How can a user-defined datatype be created?

752