Insert data from one table to another in Sql Server

 

OPTION 1 : EXPORT DATA

We can use Export data feature

• 

 

On both source and destination choose 

• 

 

 

After selecting both source and destination choose option for custom query

• 

 

 

Write  your query to fetch first 19 millions records

 

 

Choose your destination table, can specify new table (for creating)

 

Click Next and let system execute the query

 

 

 

OPTION 2: 

• By Running Query
•