1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
<HTML>
<HEAD><TITLE>BD Restore</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style.css" rel="stylesheet" type="text/css"/>
</HEAD>
<body>
<form name="form" >
<?php
$nb_fichier = 0;
echo"<p align=center><b>Choisissez un bd que vous souhaitez restaurer :</b>";
echo"<table class=liens>";
if($dossier = opendir('C:\\Users\\Mohamed\\Desktop\DRS\\Databases\\SAFSqlServer'))
{
?>
<tr>
<td class=liens>
<select name="dossier" onChange="submit();">
<option value="0">Selectionner un dossier</option>
<?php
while(false !== ($fichier = readdir($dossier)))
{
if($fichier != '.' && $fichier != '..' && $fichier != 'index.php')
{
$nb_fichier++; //On incrémente le compteur de un
printf("<option value=\"$fichier\" size=150 %s>".$fichier." </option>", (@$_GET['dossier']=="$fichier") ? "selected=\"selected\"" : "");
} //On ferme le if (qui permet de ne pas afficher index.php, etc.)
} //On termine la boucle
closedir($dossier);
?>
</select>
</td>
</tr>
<?php
echo"</table>";
echo"<br /><br />";
}
else
echo 'Le dossier n\' a pas pu être ouvert </p>';
?>
</form>
<?php
if(isset($_GET['dossier'])){
$nb_bd = 0;
$backuprep ="C:\\Users\\Mohamed\\Desktop\\DRS\Databases\\SAFSqlServer\\";
sqlsrv_configure( "WarningsReturnAsErrors", 0 );
$serverName = "SOULEYMANE\SQLEXPRESS";
$connectionInfo = array("Database"=>"master");
$conn = sqlsrv_connect( $serverName, $connectionInfo) or die(print_r(sqlsrv_errors()));
if($dossierbd = opendir($backuprep."".$_GET['dossier'].''))
//$backupfile=
$data = "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA";
while(false !== ($bdd = readdir($dossierbd))){
if($bdd != '.' && $bdd != '..'){
$nb_bd++;
//echo $bdd."<br>";
$explode = explode("-",$bdd);
$bdname = $explode[0];
$backupfile = $backuprep."".$_GET['dossier']."\\".$bdd;
/*$sqlcreate = "CREATE DATABASE ".$bdname." ;";
$execreate = sqlsrv_query($conn, $sqlcreate) or die(print_r(sqlsrv_errors()));
if($execreate){*/
$sql = "RESTORE DATABASE [".$bdname."] FROM DISK = '".$backupfile."' WITH FILE = 1, NOUNLOAD, STATS = 5";
echo $sql."<br>";
$stmt = sqlsrv_query($conn, $sql);
if($stmt === false)
{
die(print_r(sqlsrv_errors()));
}
else{
echo "ok";
$fp = fopen('extractions/'.$bdname.'.csv', 'w');
$requete = "
SELECT
[CG_ASTO_DETALLE].[CUENTA_CONTABLE] as 'Numero COMPTE'
,[DES_CUENTA] as 'Intitulé'
,[DEBITO] as 'Débit'
,[CREDITO] as 'Crédit'
,[FEC_MOVIMIENTO] as 'Date'
FROM ".$bdname.".[CG].[CG_ASTO_DETALLE],".$bdname.".[CG].[CG_CATALOGO_X_EMPRESA] where (FEC_MOVIMIENTO BETWEEN '01/01/2010' and '31/01/2011') and [CG_ASTO_DETALLE].[CUENTA_CONTABLE]=[CG_CATALOGO_X_EMPRESA].[CUENTA_CONTABLE] ORDER BY FEC_MOVIMIENTO DESC
;";
$exereq = sqlsrv_query($conn, $requete);
while( $row = sqlsrv_fetch_array( $exereq, SQLSRV_FETCH_NUMERIC) ) {
fputcsv($fp, $row);
//echo $row[0].", ".$row[1]."<br />";
}
fclose($fp);
}
}
}
}
/*echo'<p>Il y a <strong>' . $nb_bd .'</strong> fichier(s) dans le dossier</p>';*/
//echo "dossier :".$_GET['dossier'];
//serverName\instanceName
// Vu que UID et PWD ne sont pas spécifiés dans le tableau $connectionInfo,
// la connexion va tenter d'utiliser l'authentification Windows.
/*$connectionInfo = array( "Database"=>"SAF_URMEC_DIMBALANTE");*/
/*if( $conn ) {
$sql = "RESTORE DATABASE TestDB FROM DISK = '".$backup_file."' WITH RECOVERY";
echo $sql."<br>";
$stmt = sqlsrv_query($conn, $sql);
if($stmt === false)
{
die(print_r(sqlsrv_errors()));
}
else
{
echo "Database restored from $backup_file</br>";
}
echo "Connexion établie.<br />";
}else{
echo "La connexion n'a pu être établie.<br />";
die( print_r( sqlsrv_errors(), true));
}*/
//}
?>
</body>
</html> |
11/12/2012, 11h21
Restauration BD sql server avec php
00
