How are customers doing this? Customer is contemplating exporting hundreds of tables to CSV and re-importing as flex tables then materializing, but is concerned over issues with type handling and encoding in a bulk process.
How are others doing this? SSIS and ODB come to mind as options for data transfer. How are DDL translations handled, or can SSIS or ODB also create the schemas and tables in Vertica?
Question
Bulk transfer from MS SQL Server to Vertica
+2
+1Hi Bryan -
odb can also generate DDL statements. Use the switch "-ddl vertica" to get the Vertica dialect.
If you want to cross the t-s and dot the i-s, though, nothing will save you from having to profile the data for optimal data types ...
And, as to physical design, do the classic DBD thing, with an initially just representative data volume ...
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
