• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • EAS Demo Database for PFC Samples - SQL Server Version

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved EAS Demo Database for PFC Samples - SQL Server Version

  1. Issue
0
Votes
Undo
  1. John Valentin
    John Valentin
  2. PowerBuilder
  3. Friday, 27 April 2018 19:11 PM UTC

Does anyone know where I can get the EAS demo database in SQL Server format or where there are scripts to create the database and populate the tables in SQL server?

  1. PFC
To Change Data Export Property ( Method - NativePD...
Appeon Web app - when running the app in a web bro...
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Saturday, 28 April 2018 14:42 PM UTC
  2. PowerBuilder
  3. # 1

In SQL Server Management Studio (SSMS) you can create a linked server to the SQL Anywhere database. Then you can use SSMS to generate the table create scripts. After creating the tables in a SQL Server database, remove the linked server connection to SQL Anywhere.

There are 29 tables in EASDemo so it shouldn't take more than an hour to do it manually in SSMS.

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 30 April 2018 13:20 PM UTC
  2. PowerBuilder
  3. # 2

Hi John;

  I use the same technique as Roland but instead of SSMS - I just use the built-in PB Pipeline callable dynamically from the DB Painter. I can replicate the same DB into SS within about 5 minutes.

Regards ... Chris

Comment
John Valentin
  1. John Valentin
  2. Wednesday, 2 May 2018 18:12 PM UTC
I don't have the SQL Anywhere software. Just SSMS using a remove DB server. Do I need SQL Anywhere?

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 2 May 2018 18:46 PM UTC
Hi John;



  Whether use use the PipeLine (PL) or SSMS approach to replicate the EAS Demo DB database. The EAS Demo DB is an SQL AnyWhere DB - thus you will need to install SA (Developer version is free) and then rerun the PB Installation and only check the Demo App's/DB section. That should reconstitute the EAS Demo DB and then allow you to proceed to either the PL or SSMS process.



HTH



Regards ... Chris

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.