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 ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
