OZ-KBA-4005: Importing your Own Database into the OzHosting.com Database System

This KB will explain:

•    What format does the Import tool accept
•    How to Export your MS SQL Server database for Importing into OzHosting.com
•    Using the OzHosting.com MS SQL Manager

Article

What Format does the OzHosting.com Import tool accept?

OzHosting.com’s Database Import tool uses .SQL files to Import the Structure and Data from your existing Database.

How to Export your MS SQL Server Database for Importing into OzHosting.com

Open your MS SQL Server Manager

1.    Right Click Database > Task > Generate scripts
2.    Choose database
3.    Change settings to the following:
 
a.    Script for Server version: 2005
b.    Script Use Database: False
c.    Script Data: True
4.    Tick Stored Procedures, Tables and Views
 
5.    Select All for each Option
6.    Script to SQL File
7.    Edit SQL File with Notepad. You will need to change DBO Ownership to your OzHosting.com’s DB User details
8.    Run the Query via the Online Tool

Using the OzHosting.com MS SQL Manager

Once you have exported the structure and data from your existing Database you will need to follow these steps to Import it into the OzHosting.com Database server.

1.    Navigate to https://my.ozhosting.com and Log in.
2.    Click Databases
 
3.    Click the Database you wish to import your data into
 
4.    Click the link to “Browse Database Manager”
 
5.    A new window will open and you should see something similar to the following screenshot
 
6.    Click Query in the menu on the left
 
7.    You can now either copy your SQL Query to import your Database structure and data into the Text field or you can upload it from a SQL File
 
8.    Your data should now be imported