Generate Data to a Script 1

[EFREE]

Currently I have a QA database and want to update 8 records in one of the tables. I have it updated in my dev environment and created a stored procedure to see new 8 new records. I was looking for a SQL function that could generate this output of this stored procedure as an sql script so I could easily run it in my QA environment and it update the necessary table.

It sounds so easy I guess if you know what you are doing. Any help would be much appreciated!!!!!

 

[SQLDenis]

how did you update it in your QA environment
Script it out in QA run the script if everything is fine run it on the production box

Also take a look at red-gate sql compare, this tool will gernerate scrips and do a one click synchronization for you
free trial -s here (

https://www.red-gate.com/Dynamic/downloads/downloadevaluation.aspx?download=SQLBundleDeveloper)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[EFREE]

Ok I will look into this, but is there any built in SQL function to generate a script from data output by a stored procedure? The problem is I don’t want to sync the two databases because one has old data. I need to just update these specific records.

 

[SQLDenis]

no such a thing is not available

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/