Migrate from MySQL to MSSQL

Save your project 'As template'. Then create a new SQL Server project using this template as a source.

Thank you for your reply. Do I need to keep the template with my project? Will it create a copy of source codes to the project so that I can delete the template later? Thanks.

Sorry, it's me again. When I tried to add the template to my blank project, it stopped and closed the application in the middle. It also raised an application exception 0xC0000005 in the event viewer which is sanme as I mentioned in my another thread.
I am using 10.3 build 34262 x64. Thanks.

• <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">;
  
• <System>
  
  <Provider Name="Application Error" />
  
  <EventID Qualifiers="0">1000</EventID>
  
  <Level>2</Level>
  
  <Task>100</Task>
  
  <Keywords>0x80000000000000</Keywords>
  
  <TimeCreated SystemTime="2019-12-21T05:25:26.304392400Z" />
  
  <EventRecordID>28564</EventRecordID>
  
  <Channel>Application</Channel>
  
  <Computer>LAPTOP-B48GI2ED</Computer>
  
  <Security />
  
  </System>
  
• <EventData>
  
  <Data>PHPRunnerb.exe</Data>
  
  <Data>6.2.0.34262</Data>
  
  <Data>5df82902</Data>
  
  <Data>PHPRunnerb.exe</Data>
  
  <Data>6.2.0.34262</Data>
  
  <Data>5df82902</Data>
  
  <Data>c0000005</Data>
  
  <Data>00000000003a8f51</Data>
  
  <Data>bc8</Data>
  
  <Data>01d5b7bea5413b3b</Data>
  
  <Data>C:\Program Files\PHPRunner10.3\PHPRunnerb.exe</Data>
  
  <Data>C:\Program Files\PHPRunner10.3\PHPRunnerb.exe</Data>
  
  <Data>a766d623-a40a-47a1-9dbd-1e637435e998</Data>
  
  <Data />
  
  <Data />
  
  </EventData>
  
  </Event>

• <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">;
  
• <System>
  
  <Provider Name="Application Error" />
  
  <EventID Qualifiers="0">1000</EventID>
  
  <Level>2</Level>
  
  <Task>100</Task>
  
  <Keywords>0x80000000000000</Keywords>
  
  <TimeCreated SystemTime="2019-12-21T05:25:26.304392400Z" />
  
  <EventRecordID>28564</EventRecordID>
  
  <Channel>Application</Channel>
  
  <Computer>LAPTOP-B48GI2ED</Computer>
  
  <Security />
  
  </System>
  
• <EventData>
  
  <Data>PHPRunnerb.exe</Data>
  
  <Data>6.2.0.34262</Data>
  
  <Data>5df82902</Data>
  
  <Data>PHPRunnerb.exe</Data>
  
  <Data>6.2.0.34262</Data>
  
  <Data>5df82902</Data>
  
  <Data>c0000005</Data>
  
  <Data>00000000003a8f51</Data>
  
  <Data>bc8</Data>
  
  <Data>01d5b7bea5413b3b</Data>
  
  <Data>C:\Program Files\PHPRunner10.3\PHPRunnerb.exe</Data>
  
  <Data>C:\Program Files\PHPRunner10.3\PHPRunnerb.exe</Data>
  
  <Data>a766d623-a40a-47a1-9dbd-1e637435e998</Data>
  
  <Data />
  
  <Data />
  
  </EventData>
  
  </Event>
  

If you have saved your project as a TEMPLATE, you don't need to ADD it to a blank project at all. In other words, you double-click on the saved template and you'r done. Further, there is NO "PHPRunnerb.exe" in true existence at Xlinesoft's end. PHPRunner Trial Versions (that's direct to the "b" inside your PHPRunnerb.exe your loaded elsewhere...) https://xlinesoft.com/download'>https://xlinesoft.com/download under: https://xlinesoft.com/download'>https://xlinesoft.com/download - Finally, a migration from MySQL to MSSQL requires the use of a migration tool like e.g. https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017 or in other words, PHPRunner's saved template does NOT mean that PHPRunner is automatically converting your MySQL databse structure into MSSQL database structure at all. You may need to first make sure that the MSSQL database migration is done to let then the saved TEMPLATE have access to the database structure of your old MySQL project. You need then finally just to change the database connection to get the merging of the saved TEMPLATE and the new MSSQL database structure to work.

My PHPRunner is a full version and I have converted my MYSQL database to MSSQL already. The program closed with the exception error in the middle of the 'adding' business template process after I have selected my saved template. Not know what's wrong.

The saved TEMPLATE contains as well the OLD connection details to MySQL database, so you would need to first run the "old project" under MySQL, changing then the CONNECTION to database from MySQL to MSSQL inside PHPRunner. Once the connection to MSSQL database is done, you would need to save this "NEW" (MSSQL based) template then. So, when you then use the "NEW" (MSSQL connection containing template), PHPRunner can then find the MSSQL connection straightaway.

But my problem now is the whole PHPrunner program terminated unexpectedly and returned back to windows desktop.