Copy the tables, schema and views


Interview questions

Copy the tables, schema and views

Next>>         SQL Server tutorial  

SQL Server - copy the tables, schema and views - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How to copy the tables, schema and views from one SQL Server to another?

Ways to copy tables, schema and views:

  • Detach the database from one SQL Server and attach it to another SQL Server instance.
  • Script all objects in SSMS and execute the final script on the new SQL Server.

SQL Server - copy the tables, schema and views - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How to copy the tables, schema and views from one SQL Server to another? 

  • The database can be detached from one server and attached to another. Methods are : sp_detach_db and sp_attach_db
  • Scripts can be manually written using SQL’s Server management studio. SSMS is used for accessing, configuring, managing, administering, and developing all components of SQL Server.

SQL Server - copy the tables, schema and views - June 21, 2009 at 09:00 AM by Amit SAtpute

  • Wizard of SSMS can be used.
  • It can be done by detaching a database from a server and attaching it to another server.
  • The objects can be manually scripted using SSMS and then the script could be run on new server.


Also read


SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns, just like a real table..............

What is Catalog Views?

Catalog views can be used to return information like objects, logins permissions etc used by SQL server database engine...............

What are the restrictions applicable while creating views?

Answer - Views can be created referencing tables and views only in the current database.......

Sql Server database maintenance

Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.

SQL Server Reporting Services

What can SQL Server Reporting Services do? Explain the architecture of reporting services. Describe Reporting Lifecycle. What are the ways to tune Reporting Services?......

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring