Plesk Question posted in
The official documentation for Plesk Obsidian can be found here.

Export SQL server data into a CSV file – Plesk

I’ve just taken care of a project that requires converting data from the old website (built in C# web form) to the new one (using PHP).

In the old database, there is a product table contains 1600 products that I need to export into a CSV file then import to the new database but I have no idea to do that.

I can access the current server but I don’t see any .cs file (code-behind file). I also have no idea how to export that table to a CSV file using myLittleTools (The SQL server management tool that Plesk provide).

Can any have me please?

Thank you very much.

Tags:

2

Answers


  1. 0

    Try SQL Server Import and Export Wizard. This is a tool provided by MSSQL .

    Reference links here:
    https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard

    https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/get-started-with-this-simple-example-of-the-import-and-export-wizard

    You can export to either or excel or directly map two tables of different databases and transfer data

    Login or Signup to reply.
  2. 0

    According to the MyLittleAdmin site you can opent the table to view the data and export it form there.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search