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..............
Catalog views can be used to return information like objects, logins permissions
etc used by SQL server database engine...............
Answer - Views can be created referencing tables and views only
in the current database.......
Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.
What can SQL Server Reporting Services do? Explain the architecture of reporting
services. Describe Reporting Lifecycle. What are the ways to tune Reporting
Services?......
|
