Exporting data out of sql databases

I need to export data out of an sql database hosted by discountasp.net, but in the "Tools" section for CSV Import, all that is available is importing data from a CSV file.

 

You can right click on your database in the 'Object Explorer' within 'SQL Server management Studio' and then 'Tasks'>'Export Data' and provide your Database(one on DASP Server) information as Source and your Local machine database(either existing or create new) as the destination.Follow the wizard.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

'SQL Server management Studio' ?All I have is MyLittleAdmin for SQL, which only has 4 options in Tools: Query Analyzer, generate Insert scripts, the CSV importer, and change password. I'm working within my project company's budget, and all that is provided by discountasp.net is MyLittleAdmin.

 

If thats the case,then you could either create a backup using our 'SQL Tool Suite' and then download the same to your local machine and retore it using 'MyLittleAdmin'.I believe 'MyLittleAdmin' has a retore/backup tool.

Vikram

DiscountASP.NET
www.DiscountASP.NET