Knowledgebase: MS SQL
HOW TO: Copy a MS SQL Server database from a local computer to a server
Posted by on 08 December 2011 05:32 PM


How to copy a MS SQL Server database from a local computer to a server?

You need to have SQL Server 2000 Personal Edition or higher (or Client Tools only) installed on your local computer.

(How to install client tools: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_029l.asp )

I. You need to attach your existing database on local computer first. To do this, please, follow these steps:

1. Open MS SQL Enterprise Manager
2. Expand you "(local) (Windows NT)" node.
3. Right-click on "Databases" node and select All Tasks -> Attach Database from context menu
4. Click "..." (elipsis) button and browse to your .mdb file. Click "OK".
5. Click "Verify" to be sure in database integrity and click "OK".
6. Now your database is attached and should appear under "Databases" node.
 
II. How to copy databases between two SQL Server 2000 instances?

1. You need SQL Server 2000 Personal Edition or higher (or Client Tools only) installed on your local computer.
2. Open Enterprise Manager
3. Expand Microsoft SQL Servers node
4. Right-click on "SQL Server Group" node and from context menu select "New SQL Server Registration..."
5. In the "Server" field type type "202.157.177.15" (or other IP address of MS SQL server. Please contact our team if you do not know the IP), select "Use SQL Server Authentication" for "Connection" group and provide your Login name and password. Click "OK".
6. Under "SQL Server Group" expand "202.157.177.15" node and select "Databases".
7. Find your database and right-click it. From context menu select "All Tasks -> Import Data...".
8. Specify "Server" and "Database" from which data will be copied. Click "Next" button.
9. Change destination settings if it is required. Click "Next" button.
10. Select "Copy object and data between SQL Server databases". Click "Next" button.
11. Change required settings if it is required. Click "Next" button.
12. Specify when copying operation will be performed. Click "Next" button.
13. Click "Finish" button to start copying process.
14. Click "Close" button.


Copyright © 1998 - 2021 Shinjiru International Inc. All Rights Reserved.