var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Any script to generate INSERT Statements?
I need to move some data from a test server to a production server.
Is there any useful script that I can use to automatically generate INSERT statements for each table that I need to move to production?
I don't really like to use a tool like bcp as I'll be inserting some data to critical tables and seeing individual INSERT statements makes me more comfortable.
Any advice is appreciated.
No useful tool exist's, like for MS SQL Server to automaticaly generate insert statement.
I use this kind of script :
SELECT 'insert into CNSFRA..TypeTVA (Code,Libelle,CodeORFI) values ('''+RTRIM(Code)+''', ',''''+RTRIM(Libelle)+''',',''''+RTRIM(CodeORFI)+' '')' FROM TypeTVA
You should pay attention with ''.