1Export many MSSQL databases without direct access to server
$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 = '[url removed, login to view]';
$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 [url removed, login to view]'), 'border="1"');
Current server details
* Windows Server with these details
Server version : Microsoft SQL Server 2000 - [url removed, login to view] (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Server version : Microsoft SQL Server 2005 - [url removed, login to view] (Intel X86)
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2)
Server version : Microsoft SQL Server 2005 - [url removed, login to view] (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
Project ID: #1506533
About the project
5 freelancers are bidding on average $40/hour for this job
Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards