Is there a method to export sql script file from db?
tanbing001 opened this issue · 5 comments
tanbing001 commented
Is there a method to export sql script file from db?
vadz commented
No and I'm not sure this question makes sense, at least not without explaining what exactly do you mean by "SQL script file".
tanbing001 commented
I want make a copy of a local database before the columns change
…---Original---
From: ***@***.***>
Date: Sat, Oct 8, 2022 18:39 PM
To: ***@***.***>;
Cc: ***@***.******@***.***>;
Subject: Re: [SOCI/soci] Is there a method to export sql script file from db?(Issue #1000)
No and I'm not sure this question makes sense, at least not without explaining what exactly do you mean by "SQL script file".
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: ***@***.***>
tanbing001 commented
just like the database name test.db，how to get a file named test.db.sql script file that contains all data in the test.db
…---Original---
From: ***@***.***>
Date: Sat, Oct 8, 2022 18:39 PM
To: ***@***.***>;
Cc: ***@***.******@***.***>;
Subject: Re: [SOCI/soci] Is there a method to export sql script file from db?(Issue #1000)
No and I'm not sure this question makes sense, at least not without explaining what exactly do you mean by "SQL script file".
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: ***@***.***>
vadz commented
This is not something that is natively provided by the database, AFAIK, so I don't think SOCI cash reasonably provide anything like this.
A better idea would be to use the database-specific backup format (which could be SQL, as for PostgreSQL, but could also be something completely different as for e.g. SQL Server).
tanbing001 commented
ok.thanks
…---Original---
From: ***@***.***>
Date: Sat, Oct 8, 2022 20:10 PM
To: ***@***.***>;
Cc: ***@***.******@***.***>;
Subject: Re: [SOCI/soci] Is there a method to export sql script file from db?(Issue #1000)
This is not something that is natively provided by the database, AFAIK, so I don't think SOCI cash reasonably provide anything like this.
A better idea would be to use the database-specific backup format (which could be SQL, as for PostgreSQL, but could also be something completely different as for e.g. SQL Server).
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: ***@***.***>