What should we do to copy the tables, schema and views from one SQL Server to another?
We have to write some DTS packages for it.