You need to sign in to do that
Don't have an account?
Julie Nguyen 14
How to duplicate a database without using SELECT INTO in Salesforce Marketing Cloud
I'm trying to duplicate a Synchronized Salesforce database table into a Data Extension. I tried to run the query
SELECT * INTO Lead_Salesforce_Synchronized
FROM Lead_Salesforce
But got an error in return saying
The query syntax is invalid
'into' is a reserved word and may not appear in your query.
What is a workaround to this?
SELECT * INTO Lead_Salesforce_Synchronized
FROM Lead_Salesforce
But got an error in return saying
The query syntax is invalid
'into' is a reserved word and may not appear in your query.
What is a workaround to this?
After some research found below link check if that can help you.
https://salesforce.stackexchange.com/questions/122892/how-to-duplicate-synchronized-data-extension-and-put-in-data-extensions-folder
Best Regards,
Sandhya