1Export many MSSQL databases without direct access to server
$25-50 USD / hour
Cerrado
Publicado hace alrededor de 12 años
$25-50 USD / hour
I need a freelancer to create MSSQL export tool on PHP, that will be able to export a DB to SQL files, that could then be opened with some normal native SQL server`s client and imported. Then I can export each DB manually with this tool and import it into my new hosting.
The freelancer will need to take export db part from phpmssqladmin and rewrite it in odbc way
Here is code that will help:
<?
$server = '[login to view URL]';
$database = 'nidary_com';
$user = 'nidary_com';
$password = '*Ah17275d!!';
$con = odbc_connect("Driver={SQL Server};SERVER=$server;DATABASE=$database;", $user, $password);
echo odbc_result_all(odbc_exec($con, 'select * from [login to view URL]'), 'border="1"');
Current server details
* Windows Server with these details
Server version : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Server version : Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2)
Server version : Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2)
* You can enable PHP
* shell access is disabled: through ASP and PHP
* also we can't connect to DB with standard tools, only online at a URL
* Cannot connect through PHP with mssql_connect
* Can connect with odbc_connect
* for export of DB you can use phpmsadmin, but it uses mssql_connect -- you must extract db-export logic from it to convert it to use odbc_connect