EZcash Software

EZcash Migration MYSQL to SQLServer

Posted on

To begin, select the database type. Next, you’ll need to type in the ODBC alias for the source and destination databases. Once those are typed, click “Open” for each one. When opened successfully, you will see a message in the “Messages” area, and the “Go” button will be enabled. If you want to clear data […]

JPEGger Imaging Software

JPEGger Migration MYSQL to SQLServer

Posted on

Detailed instructions with screen shots are in the attached article. BatchMove is for JPEGger mYSWQL to SQLServer Migration. For EXcash MYSQL to SQLServer migration, use Mygrator instead – see reference article. The BatchMove installation program is also attached. Attachments: How To Upgrade JPEGger and Migrate JPEGger Images from MYSQL to SQLSERVER BatchMove.sfx.exe Related Articles: EZcash […]

SQL Server

Create a new log file from a command line

Posted on

If the log file is too large and you want to create a new log. Detach the database. Rename the old log file to something like jpegger_log1.ldf (or move it to another directory). Then from Management Studio, open a new query and enter the command: create database [jpegger] on (FILENAME = ‘C:\jpegger.mdf‘) for attach_rebuild_log where […]

SQL Server

Moving the tempdb database

Posted on

Moving the tempdb database You can move tempdb files by using the ALTER DATABASE statement. Determine the logical file names for the tempdb database by using sp_helpfile as follows: use tempdb go sp_helpfile go The logical name for each file is contained in the name column. This example uses the default file names of tempdev […]

SQL Server

Symptoms: Xlate start up error.

Posted on

Symptoms: Xlate start up error. Cause: Xlate needs to be run as Administrator. Resolution: Goto C:\windows\SysWOW64\ right click XlateApp choose properties, Compatibility tab and Check the Privilege Level check box “Run this program as an administrator” Attachments: Xlate64 Bit