Insert Generator?

Question

I'm just wondering if somebody can point me in the right direction for creating an insert generator within the confines of SQL? I have a Microsoft SQL database that I want to export to multiple anti-standard databases for some testing and think this would be a good method for moving the data.

Any help would be greatly appreciated.

did you mean to tag with mysql? – Mitch Wheat Dec 10 '11 at 06:11 — Mitch Wheat, Dec 10 '11 at 06:11

score 2 · Accepted Answer · edited May 23 '17 at 11:55

2

There is one built in to SSMS. Tasks->Generate Scripts.... See this answer: Script all data from SQL Server database

Also, check out SSMS Tools Pack.

edited May 23 '17 at 11:55

Community

1
1

answered Dec 10 '11 at 06:02

Mitch Wheat

295,962
43
465
541

Thank-you very much - I actually used SSMS to get the data from Access into Microsoft SQL in the first place, I didn't realize this was also available. More for curiosities / educations sake - Is there a way to do something like this in SQL and if so what do you recommend I read up on to accomplish this? – Michael A Dec 10 '11 at 06:03

score 1 · Answer 2 · edited May 23 '17 at 12:11

1

I'd like to lead you to this post:

What is the best way to auto-generate INSERT statements for a SQL Server table?

In which @ShaneFulmer posts:

http://vyaskn.tripod.com/code/generate%5Finserts.txt

edited May 23 '17 at 12:11

Community

1
1

answered Dec 10 '11 at 06:02

Nonym

6,199
1
25
21

Oh.. my bad, you are so right.. and I totally misread the post for wanting to export for just one table (and not the entire database), which might have taken longer than running the scripts in the link :( .. Should I remove my post? – Nonym Dec 10 '11 at 06:14
Worth retaining for interests sake in my opinion - I think there's knowledge to be gained from it – Michael A Dec 10 '11 at 06:45

Insert Generator?

2 Answers2