In SQL Server 2008 it is possible to script data from SQL Server Management Studio.
I would like to make a job, that scripts everything in my database (tables, stored procedures etc) to one file and all data in some tables to another.
Is it possible - and what is the easiest way to do it?
The reason why I want this is so I can put my development databases under source control.