We have to write some DTS packages for it.

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

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a trigger what are the advantages of trigger?

943

What do you mean by recursive stored procedure?

912

What stored procedure can you use to display the current processes?

854

Explain tablesample?

969

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

905

What are the various editions of sql server 2017 that are available in the market?

859

What is side by side migration in sql server?

1053

Describe different Processing Modes offered by SSRS?

236

What is after dml trigger?

978

What are the different types of data sources in ssrs?

192

Some queries related to SQL

943

How to create indexed view?

1004

What happens if an integer is too big for int date type?

938

Why main is user defined function?

969

What is a covered index?

905