1Export many MSSQL databases without direct access to server

Closed Posted Mar 15, 2012 Paid on delivery
Closed

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

Database Administration PHP SQL

Project ID: #1506533

About the project

5 proposals Remote project Active Apr 17, 2012

5 freelancers are bidding on average $40/hour for this job

SICS

Please check the private message

$25 USD / hour
(32 Reviews)
6.5
weonlydo

Hi, this will be a brief walk in the park for me. Please see PM

$50 USD / hour
(49 Reviews)
5.9
mmpl005

Sir,please check your pmb.

$25 USD / hour
(3 Reviews)
3.3
Z5X4DJu9q

Check PMB please.

$50 USD / hour
(0 Reviews)
0.0
mikewilson007

Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

$25 USD / hour
(0 Reviews)
0.0