2. PHPRunner General questions
  3. re-link phprunner from Access database to SQL Server database
This topic is locked

re-link phprunner from Access database to SQL Server database

 		4/30/2021 4:23:59 PM
PHPRunner General questions
M
 mfonseca author

Hi all,

I've developed an application with phprunner connected to an Access database using ODBC.

I've migrated the database to SQL Server with the same table names, fields names, etc.

I've re-linked the project to the SQL Server database but all pages are lost.

How can I use the existing application with the new database?

Thanks for your help

img alt

img alt

admin 4/30/2021

The problem that is specific to these two databases, MS Access and SQL Server, is that table names in the project are not the same, tbl_Operadores vs dbo.tbl_Operadores. These are two different names.

What you can try is to save your MS Access project 'As template' and then create a new project pointing it to SQL Server database and using this newly created template.
M
 		mfonseca author 5/3/2021

Thank you for the tip.
I'll try it.