How to import/export data from sql server hosted remotely using query only!

Posted by Coolbharat under Sql Server on 3/13/2014 | Points: 10 | Views : 1445 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,
We managed to create BackUp of a database hosted remotely or in shared hosting environment by using Export/Import Wizard in SSMS by right clicking database in SSMS.Then we can have the version of database in our local sql server which can be taken BackUp of.But we want to do ot using query only without using wizard so that the instance of the database can be created in our local server and we can proceed usually to create .BAK file of the database.How can we do it?

Thanks in advance

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 3/14/2014 [Member] [MVP] Platinum | Points: 25

0	Means you want to take back up remote server database and then restore that backed up data to your local database? Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Coolbharat, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts