What should we do to copy the tables, schema and views from
one SQL Server to another?
Answers were Sorted based on User's Feedback
Answer / kmbkrishnan
Copy Database wizard is one of the option to copy a
Database to another Database.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Write a sql query to get zero records from a table having n number of records?
Which tcp/ip port does the sql server run on? How can it be changed?
What is the difference between varchar and nvarchar?
What is normalization of database?
Define Unique Key?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the difference between functions and stored procedures?
Can binary strings be converted into numeric or float data types?
what is the sql equivaent of the dataset relation object ?
How will you make an attribute not process? : sql server analysis services, ssas
How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
What is the Disadvantage of indexed sequential file.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)