1. 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?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 30 April 2018 13:20 PM UTC
  2. PowerBuilder
  3. # 1

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
  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
  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.
Roland Smith Accepted Answer Pending Moderation
  1. Saturday, 28 April 2018 14:42 PM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


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