1. John Valentin
  2. PowerBuilder
  3. Friday, 27 April 2018 19:11 PM

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
  2. PowerBuilder
  3. # 1
0
Votes
Undo

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
I don't have the SQL Anywhere software. Just SSMS using a remove DB server. Do I need SQL Anywhere?

  1. John Valentin
  2. Wednesday, 2 May 2018 18:12 PM
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. Chris Pollach @Appeon
  2. Wednesday, 2 May 2018 18:46 PM
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Saturday, 28 April 2018 14:42 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

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.