In this video tutorial I will show you how to export data from remote server (godaddy live server) to local database. First of all create a database name in local server (any name) called “godaddyBackup”. Next connect your remote server using server name (IP address) and password. Select your database from remove server
Right click on the database you wish to backup and Click Task à Export Data.
Choose Source Data:
This pops open a wizard where you can choose the Data Source from which to copy data.
Select Server name and Use SQL server authentication, Username and password. Then select database from the dropdown list and click next.
Choose a Destination:
Select local server name Use SQL server authentication, Username and password. Same as previous select database from the dropdown list where to export data and click next.
Specify Table Copy or Query
Use radio button to and “select copy data from one or more tables or views”. And click next button.
Select Source Tables and Views:
Choose more tables and views to copy from the list and click next button.
Run Package
Click Next button. Then next, click finish button.
After performing some operation data will be exported from the remote server to local server.
Open the local database and see your exported data.
Post your comments / questions
Recent Article
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
- ModuleNotFoundError: No module named 'openpyxl' - Python
- How to get thumbnail from vimeo video URL in Python?
- Remove all special characters, punctuation except spaces from string - Python
- OSError: cannot write mode RGBA as JPEG- Python
- expected str, bytes or os.PathLike object, not JpegImageFile - Python
Related Article