Configure the BCS Database
Scenario/Problem: You want to use a new database for the BCS service application.
Solution: Use the Set-SPBusinessDataCatalogServiceApplication cmdlet with the DatabaseName parameter.
When the Business Data Connectivity Service Application is created, by default, the database name is Bdc_Service_DB_<guid>. You can easily change this to a new database using the DatabaseName parameter with the Set-SPBusinessDataCatalog ServiceApplication cmdlet, as shown in Listing 15.3.
Listing 15.3. Configuring a New Database for BCS
$bcs = Get-SPServiceApplication -Identity b7b3652e-6f51-4161-935a-0631a1100ecfSet-SPBusinessDataCatalogServiceApplication -Identity $bcs -DatabaseNameBCS_DB
If the database does not exist, a new database ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access