Several years ago I've been using Redgate tools for schema compare and data compare, also for packaging databases for deployment. I just installed an evaluation version of SQL Toolbelt and have run into problems related to the tools' functionality, as they are no longer intuitive to me.
In particular, I would like to find out:
1) how to script a db schema using SQL Toolbelt tools? I can do it from SSMS, but what is missing from it are the PRINT statements, that Redgate tools inserted to provide progress information, which affects my automated programmatic deployment process. I need the PRINT statements in order to get SQL script execution progress using SQL Server SMO objects in .NET.
2) how to script data from a db, also with included PRINT statements, providing progress information? Again, I can do it from SSMS level, but it's not exactly the same as I remember when I was using an older version of SQL Toolbelt.
Basically, in 1) I want to point a Redgate tool to a DB and tell it to generate DDL script (with PRINT statements inside, providing progress information), and in 2) I want to point a Redgate tool to a DB and tell it to generate INSERT statements (also with PRINT statements inside, providing progress information).
How do I do that?
PS. There should be a forum for an entire SQL Toolbelt suite, not only a particular tool. From the current names of Redgate tools, I cannot infer where my questions truly belong.
You can script this stuff out in SQL Compare or SQL Data Compare, but I would use Redgate SQL Source Control. This allows you to link your dev DB in SSMS to your VCS or just a plain old directory on your filesystem ("working folder") and to keep it up to date.
In particular, I would like to find out:
1) how to script a db schema using SQL Toolbelt tools? I can do it from SSMS, but what is missing from it are the PRINT statements, that Redgate tools inserted to provide progress information, which affects my automated programmatic deployment process. I need the PRINT statements in order to get SQL script execution progress using SQL Server SMO objects in .NET.
2) how to script data from a db, also with included PRINT statements, providing progress information? Again, I can do it from SSMS level, but it's not exactly the same as I remember when I was using an older version of SQL Toolbelt.
Basically, in 1) I want to point a Redgate tool to a DB and tell it to generate DDL script (with PRINT statements inside, providing progress information), and in 2) I want to point a Redgate tool to a DB and tell it to generate INSERT statements (also with PRINT statements inside, providing progress information).
How do I do that?
PS. There should be a forum for an entire SQL Toolbelt suite, not only a particular tool. From the current names of Redgate tools, I cannot infer where my questions truly belong.