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
3353 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
umap
over 7 years ago
I took a backup of the Db from one instance of SQL server and restored it on another instance of SQL server on the cloud.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
umap
over 7 years ago
I took a backup of the Db from one instance of SQL server and restored it on another instance of SQL server on the cloud.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data