This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Copy App ( Spreadsheet to SQL ) skips 2 tables

Posted on 10-06-2023 04:44 AM
volczi
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi,

I have an app with 10 tables. The source of the tables are sheets within the same spreadsheet.

I want to move from spreadsheet to SQL. I copy the app and select the target SQL database. The copy succeeds but only 8 tables are copied. The remaining two are still linked to the original spreadsheet so it is shared between the original and the copied app.

I guess the copy failed on something but I can't find the reason.

( I tested with MySQL and Postgre, same result )

Did you face this problem?
Is there a way to check the logs of the copy operation? 

Thanks in advance!
Volczi

0 2 123
Topic Labels
0 Likes
Reply
2 REPLIES 2

Posted on --/--/---- --:-- AM
volczi
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

I found the problem for one of the tables: There was a duplicated key in the sheet. ( I modified the sheet manually weeks ago for test purposes ) I removed that row and did the copy again and the table is there in SQL. ( Still investigating the second table )

0 Likes
Reply

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
Reply posted on --/--/---- --:-- AM

Copying data is a handy but not a 100% reliable way to copy the app.
I hope feedback like yours pushed this to be a more stable feature

Reply
Top Labels in this Space