Tuesday, June 5, 2007

Microsoft Sql Server2000

To connect to a remote database server from local.

In Ms sql server , clik on enterprise manager. In the console you will have the databases listed in the tree structure.In that tree Right-Click on the "SQL Server Group" item.In the poup menu click "New sql Server registration".It will open a wizard.In the Welcome wizard press Next. Then another wizard appears asking to select a server from the available server.If you dont see one , just type the ip address and add it.On clicking Next, You will need to set authentication mode in another wizard, then you need to selectsql server group.Atlast Finish.After the process succeeds, you can see the database added to your existing database.To be more precise, it is not only the database, but also one among the "SQL Server Group". So any changes made to this database , will be affected in the server.

If you want to import the database for local testing alone, then follow the below procedure.

First create a database with the name of the database that you are going to import.Then Right-click on the local "SQL Server Group" and click on "All Tasks".In that select "Import Data". Then you will be going through a set of wizards,that asks for input.In the "Import/Export" wizard click Next.Then in "Data Source" wizard, specify the server address, then choose appropriate authentication and then choose the database to be imported.Then in the "Destination" wizard , choose the "Local" system as server, give the appropriate authentication and then choose the database you created in the local system.Then in the "table copy or query" wizard , choose "copy objects and data between sql server databases" option.Then click on Next in the following wizard. A copy of the database will be copied from the server to the local one.

No comments: