Transferring SQL databases from client to SQL server

Problem:

Solution:

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".

STEP 9 : Help ! If nothing works try this

Sometimes understanding a HOW TO could be confusing process and If you have any questions or experience any difficulty, please send us a support ticket & we'll help you through it as best we can.

Click here to send us a ticket Now.

База знань

Категорія

Категорія

Problem:

Solution:

Схожі статті

Підтримка

База знань

Категорія

Категорія