How to identify the database type for my Creatio cloud instance:

I need to determine which database my cloud Creatio instance is using (MSSQL, PostgreSQL, etc.). What's the simplest way to check this information?

 

Best practices for migrating large datasets from Pre-Production to Production:

I'm familiar with the Data Binding tool and standard migration procedures, but I'm working with extremely large datasets that make the standard approach challenging.

What's the recommended method for migrating substantial amounts of data between Pre-Production and Production cloud environments? Are there optimization techniques, alternative tools, or best practices specifically for handling large-volume migrations?

Any insights from those who've successfully managed large-scale data migrations would be appreciated!

Like 1

Like

1 comments

Hello,
 

Please contact the Creatio Customer Support directly to provide you with the information regarding your cloud-based site. Here is the support email address: support@creatio.com.

Show all comments

Hi 

Have created stored proc through sql script but it was failed when trying to install. Considering SQL script execution is passed, will those SQL scripts be created in database, shall we assume that  each business will have separate database in Creatio?

Like 0

Like

4 comments

Hello,
 

With which error, the installation of the script failed?

Hi, I am using SQL script in MSSQL. Please find my script below for creating Proc. 'UsrMemberData' is the object which i created in my app.

 

IF OBJECT_ID('UsrMemberData', 'P') IS NOT NULL BEGIN
   DROP Procedure UsrMemberData;
END
GO

CREATE Procedure UsrMemberData 
Begin
    SELECT * FROM UsrMemberData
End

 

It shows below error


Is SQL Script is working ony for any specific DBMS type? Can you please let me know how to work out this .

 

Thanks!

 

 

Hello,

 

The issue is likely due to the case sensitivity of SQL Server keywords and the positioning of the GO statement. Here’s the corrected script with proper syntax:

IF OBJECT_ID('UsrMemberData', 'P') IS NOT NULL 
BEGIN
   DROP PROCEDURE UsrMemberData;
END
GO

CREATE PROCEDURE UsrMemberData 
AS
BEGIN
   SELECT * FROM UsrMemberData; -- Assuming UsrMemberData is a table
END
GO
 

Hi,

Have tried with above code but still got the issue

 

Please find the script below,

 

IF OBJECT_ID('UsrMemberDataRetrieve', 'P') IS NOT NULL 
BEGIN
  DROP PROCEDURE UsrMemberDataRetrieve;
END
GO

CREATE PROCEDURE UsrMemberDataRetrieve 
AS
BEGIN
  SELECT * FROM UsrMemberDetailsData; 
END
GO

 

Can you please let me know sql script is compatible with any specific DBMS type. Thanks!

 

 

 

 

 

 

Show all comments