Efficiently Moving Large Tables to a Different Database using the SQL command 'Create Table As Select' (CTAS)

Efficiently Moving Large Tables to a Different Database using the SQL command 'Create Table As Select' (CTAS)

Using the Actian X / Ingres Star product can provide you with a very efficient way to move tables between databases which may be on different versions of OS, versions of Database Software and in different geographical locations! Find out more from watching this video.

rate limit

Code not recognized.

About this course

At the end of this course you will:
Have an understanding of how Ingres STAR can assist you to move data around your database estate easily and efficiently.  Ingres STAR removes all issues in relation to OS version, database software versions and can easily bridge the geographical location issue to provide an efficient way to move data.
Course Style:
The style is informational providing you with insight into the power of Ingres STAR when migrating data between your database estate.
Audience:
For System or Database Administrators who have responsibility for maintaining Corporate Actian X / Ingres Databases.
Prerequisites:
The course assumes that the learner will be a Database Administrator and have knowledge of the Actian X / Ingres database software.
The content in this video relates to Actian X / Ingres Database Software versions 11.x and above.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum9 min

  • Moving Large Tables to Different Database Using CTAS 9 min
  • Feedback
  • Take Course Survey

About this course

At the end of this course you will:
Have an understanding of how Ingres STAR can assist you to move data around your database estate easily and efficiently.  Ingres STAR removes all issues in relation to OS version, database software versions and can easily bridge the geographical location issue to provide an efficient way to move data.
Course Style:
The style is informational providing you with insight into the power of Ingres STAR when migrating data between your database estate.
Audience:
For System or Database Administrators who have responsibility for maintaining Corporate Actian X / Ingres Databases.
Prerequisites:
The course assumes that the learner will be a Database Administrator and have knowledge of the Actian X / Ingres database software.
The content in this video relates to Actian X / Ingres Database Software versions 11.x and above.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum9 min

  • Moving Large Tables to Different Database Using CTAS 9 min
  • Feedback
  • Take Course Survey