Export structure and data without a wizard

Question

Using Sql Server 2008 R2 (but I could possibly upgrade if required).

I want to generate scripts for the database structure as well as the data for a schema.

The Generate Scripts wizard does what I want but I need to be able to automate it (so needs to be called from T-SQL or alternatively external program).

How can I do this?

score 0 · Answer 1 · edited Jun 15 '20 at 09:05

0

I know that Red Gate SQL compare has a command line interface so you could write and schedule a batch file to generate the scripts. Details here

You could then use SQLcmd to execute the scripts.

edited Jun 15 '20 at 09:05

Community

1

answered Oct 16 '14 at 13:02

James Anderson

5,794
2
27
43

score 0 · Answer 2 · edited Apr 13 '17 at 12:42

0

Probably you want to try PowerShell scripting for this.

edited Apr 13 '17 at 12:42

Community

1

answered Oct 16 '14 at 19:39

yahor

131
5

Export structure and data without a wizard

2 Answers2