Knowledgebase
Portal Home > Knowledgebase > Windows Hosting > MsSql database > Transferring SQL databases from client to SQL server
Transferring SQL databases from client to SQL server
| Use following steps:
| STEP 1: |
|
From the Start Menu  select "Programs" "Microsoft SQL Server" "Import and Export Data" then click "Next.
| STEP 2: |
|
In the "Server" field, type in the Name or IP of the source server (your local machine Ip) choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field click "Next".
| STEP 3: |
In the "Server" field, type in the hostname of the remote SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your database username and password, choose your database from the "Database" field click "Next".
| STEP 4: |
|
Choose "Copy objects�" click "Next".
| STEP 5: |
|
Uncheck Use Default Option.
| STEP 6: |
|
Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions".
| STEP 7: |
|
Leave next window as is, click "Next".
| STEP 8: |
|
Click "Finish".
|
|
|
|
|
|
|
|
|
 Add to Favourites
 Print this Article
|
Also Read
Powered by WHMCompleteSolution
get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server? (Views: 675)
