moving of table from one instance to other instance

MOVING OF A TABLE FORM ONE INSTANCE TO OTHER

lets take 2 different instances NLR & BLR and 2 different database as one and two in each of the instance and table name STUDENT

lets see the student table has the data of about  196608 records as shown

we have to move it form NLR to BLR instance

go to one database in nlr instance ==> one database  right click==>task==>generate scripts

as shown

next follow below screen shorts

select the database in which table is present

in the next dialog box select the following to true

script data ==> true

script index==>true

 

next go to file location right click edit ==>copy all the script and paste in the blr instance and change the name database at the staring of the script and write the database name two and execute the script

thats all how to move the data between two different instances