What should we do to copy the tables, schema and views from
one SQL Server to another?
- 3 Answers
- 9445 Views
- I also Faced
- E-Mail Answers
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
What is subquery? Explain the properties of a subquery?
What kind of problems occurs if we do not implement proper locking strategy?
what is the difference between openrowset and openquery?
What is a coalesce function?
Does view occupy space?
do you know how to configure db2 side of the application? : Sql server database administration
When should you use an instead of trigger?
What is self contained sub query?
How do I find the sql server version?
Disadvantages of the indexes?
Can you index views?
What is normalization and what are the advantages of it?
Can one drop a column from a table?
Where can you add custom error messages to sql server?
Explain “row_number()” in sql server with an example?
