Generate INSERT statements from existing SQL Server table

Data and Databases
1

How can I create SQL scripts with INSERT statements from my current table?

I’ve got a table in SQL Server 2008 that I need to move to another database server. I’m wondering if there’s a way to generate a script with INSERT INTO statements for all the data in my table. This would make it easy to recreate the data on the new server.

I’m using SQL Server Management Studio and I’ve looked through the options, but I can’t seem to find anything that does this automatically. Is there a built-in feature or a workaround to get this done?

I’d prefer not to write all the INSERT statements by hand, as the table has quite a few rows. Any suggestions on how to accomplish this would be really helpful!

2

hey, try using ssm’s ‘script table as’ > ‘insert to’. it auto generates the insert statements, so double check them before running. hope it works for ya.

3

have u considered using the ‘Generate Scripts’ wizard? its pretty nifty! u can find it by right-clicking ur database, then ‘Tasks’ > ‘Generate Scripts’. it lets u pick specific tables and even data. might be worth a shot! what size is ur table btw?