SQL Server Database?

Question

Platform:Sql server 2003
Two boxes: 1)production server/machine 2)Test server/machine
How to move the database from the production server to Test server?
how to move the complete structure,logins n all to test server?

As the data is huge i dnt need it in test sever but i at times to work how can i move the data of my choice?

thank you in advance
send me links or better still the a document

10 points.. waiting ..

Answer 1

There is no SQL Server 2003. There is SQL Server 2000 or 2005.



In SQL Server 2000, you can use Enterprise Manager's Import / Export feature to move databases between machines, provided they are on the same network or are both reachable through the same network. Just add both servers in your Database explorer.



The import / export will allow you to use a query / stored procedure to select the data you want.



You can also use Data Transformation Services to automate this process, if you need to update data /users / schemas between the servers on a regular basis.



Enterprise Manager comes with SQL Server 2000.



In SQL Server 2005, you can use the Management Studio that comes with it, through the Object Explorer. You could either use replication or simply drag-and-drop the objects you want to copy between servers. You can also fully script any action between servers in Managerment Studio and schedule them as jobs.

Answer 2

DTS is a set of methods you should use to import, export, and remodel heterogeneous information between one or extra information resources, inclusive of Microsoft sq. Server, Microsoft Excel, or Microsoft get proper of entry to. Connectivity is provided by OLE DB, an open-known for information get proper of entry to. ODBC (Open Database Connectivity) information resources are supported by the OLE DB service for ODBC. You create a DTS answer as one or extra applications. each and every equipment would contain an prepared set of projects that outline artwork to be achieved, transformations on information and products, workflow constraints that outline job execution, and connections to information resources and places. DTS applications also grant amenities, inclusive of logging equipment execution information, controlling transactions, and dealing with international variables. those methods are available in for starting to be and executing DTS applications: The Import/Export Wizard is for progression somewhat user-friendly DTS applications, and helps information migration and straightforward transformations. The DTS clothier graphically implements the DTS merchandise type, allowing you to create DTS applications with an excellent kind of function. DTSRun is a command-instantaneous application used to execute modern-day DTS applications. DTSRunUI is a graphical interface to DTSRun, which also helps the passing of international variables and the technology of command lines. SQLAgent isn't a DTS software; besides the undeniable fact that, it really is used by utilizing DTS to schedule equipment execution. utilizing the DTS merchandise type, you could also create and run applications programmatically, construct custom projects, and construct custom transformations.

Answer 3

You may find the answer here



http://www.w3computing.com/sqlserver/