GENiALi's Blog

inDE Original

0TweetsRetweet

Who doesn't know that. To create table a in a current project new and development during fills it with data. They are also a good idea and could be applied in the live system.

But how get it without great struggling in the live system?

We circulated a Transact SQL where you could specify the table until recently. Then still a Transact SQL generated one where you have the WHERE clause had to adjust. Then we had a lot insert's not worked for some column names but. This was only...

Then, looking for a tool, I found the SQL Dumper Ruizata project.

Absolutely awesome. It specifies the server, the database, and then selects what you want to export.

Generated in the following form is a (examples are from the website of the project).

INSERT INTO dbo.TABLE VALUES (98, 'Pedro Rubina')
INSERT INTO dbo.TABLE VALUES ('John Riley' 96)
INSERT INTO dbo.TABLE VALUES (27, 'Sandra Moutinho')

Or:

SET IDENTITY_INSERT dbo.TABLE ON

INSERT INTO dbo.TABLE(code,_name) VALUES (98, 'Pedro Rubina')
INSERT INTO dbo.TABLE(code,_name) VALUES ('John Riley' 96)
INSERT INTO dbo.TABLE(code,_name) VALUES (27, 'Sandra Moutinho')

SET IDENTITY_INSERT dbo.TABLE OFF

Oh yeah. The tool doesn't cost. :-)