Link to home
Start Free TrialLog in
Avatar of vbnetcoder
vbnetcoder

asked on

create insert script based on records in a table

how do i create an insert script for the records currently in a table?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbnetcoder
vbnetcoder

ASKER

ty
Just for the record, to have the INSERT commands in a script, right-click on the database name, choose Tasks / Generate Scripts... then specify the table or tables that you want and then click in the Advanced button and scroll down until the option "Types of data to script" and change it to "Data only" (default is Schema only).
thank you!