0

I'm working with sqlsrv on php. I tried to export my database into .sql file but it didn't work. Can someone please help me?

i tried this,

$file = '/sqlsrv/backup.sql';
$result = sqlsrv_query($conn, "SELECT * INTO OUTFILE '$file' FROM '##table##'") or die( print_r( sqlsrv_errors(), true));
Fatemeh Abdollahei
  • 3,040
  • 1
  • 20
  • 25
Nandan T Rsn
  • 5
  • 4

1 Answers1

0

Its seems there is nothing like INTO File in MsSql. You could have a look at this one and this as well

Abbasi
  • 617
  • 7
  • 14