Last Updated on
Question: Support has requested that I export a table for them from my database. What is the process for both MySQL and MSSQL?
MSSQL: We will be using the example of MSSQL 2008 R2 since that is what ships with Ephesoft.
1. Log into SQL Server Management Studio
2. Right click on the database where the table you would like to export is
3. Move the mouse arrow over ‘Tasks’ and click on ‘Generate Scripts…’
4. Click next through the introduction page, and when on the Choose Objects selection screen, select ‘Select specific database objects’
5. Select the table(s) which you would like to export and click Next >
6. On the ‘Set Scripting Options’ screen, set the FileName and location to which you would like to script the table. Then Click ‘Advanced’.
7. In the Sdvanced Screen, scroll down and for the option ‘Types of data to script’, Change this from ‘schema’ to ‘Schema and data’ and click ok.
8. In the Summary page, you will click Next and it will export your table. Please upload this file to the Ephesoft FTP server inside of a folder named for your support Ticket (ex. EPHE-7777)
1. Open a command prompt with administrator rights on the server which hosts the MySQL installation
2. Using the specific information for your MySQL installation, type in and execute the command below:
mysqldump -p -u userName databaseName tableName > tableName.sql
A sample of this from an Ephesoft server with default settings exporting the batch_instance table is:
mysqldump -p -u ephesoft ephesoft batch_instance > c:\batch_instance.sql
3. You will be prompted for the password for the user with whom you are connecting to MySQL.
4. Upload the file to the Ephesoft FTP in a folder named after the Ephesoft ticket in which you were asked to upload the table. (This is very important)
A few notes:
With Ephesoft, the default databases are either ‘ephesoft’ or ‘report’
You can designate any path for the output file. In the example above, I placed the file in the root ‘c:\’ directory. If you do not designate a directory and only a filename, the file will be created in whichever directory the command prompt is in.