Generate Script wizard scripting schema and data to ignore "GO"

user_2268936 0
Viewed 1011

I am using SSMS Generate Scripts wizard to script the schema and data for few tables in my database. Somehow the end result will add "GO" after certain insert script.

Is there any way to prevent SSMS adding "GO" from the generated script?

Thanks,

ssms tsql sql-server
2 Answers

Option "Delimit individual statements" is available in General scripting options (Tools -- Options -- SQL Server Object Explorer -- Scripting). SSMS Options

user_32544160

I could not find the option but ended up using a powershell script to clean it up

(Get-Content -Path $fileName) | Where-Object { $_ -notlike 'GO' } | Set-Content -Path $fileName
user_22689360
Related