Split generate data insert from SQL Server [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed last year.

Improve this question

I have a table with a lot of data in the development environment. I want to generate an SQL Script for data load in production.

Using the function to generate the script in SQL Server, I can only see the split based on tables. Some tables have millions of records. I like to split this data script into multiple scripts.

Is there a configuration for that?

Using the function - what function? ' I like to split this data script into multiple scripts.' - what does this mean? — P.Salmon
– P.Salmon, Commented Aug 2, 2024 at 8:25
Are you talking about the "Generate Scripts" functionality in SSMS with data included? Doing millions of single row inserts won't be a good way of doing this anyway (especially if they are all running as standalone autocommit transactions) — Martin Smith
– Martin Smith, Commented Aug 2, 2024 at 8:32
You can look here perhaps stackoverflow.com/questions/37003017/… it seems that SMO which ssms uses have option to enumerate scripts, although i'm not sure if it's enumerable by sql statement or sql statement type — siggemannen
– siggemannen, Commented Aug 2, 2024 at 9:20

Melvin Kosisochukwu · Accepted Answer · 2024-08-02 08:27:56Z

2

You could create a view table as a work around, this will be be two virtual tables, one holding the top half and the other view table holding the bottom half.

answered Aug 2, 2024 at 8:27

Melvin Kosisochukwu

7644 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Enrico Over a year ago

In this case, the procedure doesn't generate le script for data for view

siggemannen Over a year ago

Wouldn't the scripts then have stuff like: insert into ViewTable1... Insert into ViewTable2... code which needs to be replaced?

Collectives™ on Stack Overflow

Split generate data insert from SQL Server [closed]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related