Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
8 subscribers
Views
3352 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Data Store - change the data source
umap
over 7 years ago
I have an exsiting Data store with Data Source (DS1) , DS1 is legacy. I cloned the database from the data source for this DS1 and put this onto new Data Source (DS2).
When I go to the Data Store and try to change the Data Source from DS1 to DS2 - it complains about tables not existing when you try to verify.
Also, the Appian generated DDL has multiple Nulls - causing SQL to error on creating the schema. Please suggest how to point to a new data source successfully.
eg: create table [Instructors] (
[InstructorID] int identity not null,
[InstructorQuals] VARCHAR(MAX) NULL null,
[FirstName] VARCHAR(50) NULL null,
[LastName] VARCHAR(50) NULL null,
primary key ([InstructorID])
);
OriginalPostID-257045
Discussion posts and replies are publicly visible
Parents
0
Sally Mason
Appian Employee
over 7 years ago
When you say you "cloned" the datasource, did you also take the other steps to add the new DS either through the Admin Console or ds-xml?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sally Mason
Appian Employee
over 7 years ago
When you say you "cloned" the datasource, did you also take the other steps to add the new DS either through the Admin Console or ds-xml?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data