Question: I'm trying to do a database migration using `GCP Database Migration Service`

My source database is of `Postgres` type (hosted on `Heroku`), but the name of the database is not `postgres` but rather something like `d12bdsdjs` ...

My question is ... is there a way for me to use the `GCP Database Migration Service` to somehow migrate this database ? There seems to be no field on the form where I can provide this value in `GCP console` ... maybe I can somehow set it if I create my `migration job` using the `GCP SDK` or something ?

Please advise

Answer: 
You could use a [hash table](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_hash_tables?view=powershell-7.2) or [ordered dictionary](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_hash_tables?view=powershell-7.2#creating-ordered-dictionaries) (if you need the keys to keep their order), might be a good approach for your need.

* Hash Table

```
$hash = @{
    server1 = "SID1"
    server2 = "SID2"
}

```

* Ordered Dictionary

```
$dict = [ordered]@{
    server1 = "SID1"
    server2 = "SID2"
}

```

Then you can [iterate over the key / value pairs](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_hash_tables?view=powershell-7.2#iterating-over-keys-and-values) either using `.GetEnumerator()`:

```
foreach($pair in $hash.GetEnumerator()) {
    Write-Host ("Server={0} and SID={1}" -f $pair.Key, $pair.Value)
}

```

Or by it's `.Keys` property:

```
foreach($key in $hash.PSBase.Keys) {
    Write-Host ("Server={0} and SID={1}" -f $key, $hash[$key])
}

```
```
$array1 = @("server1", "server2")
$array2 = @("SID1", "SID2")

for($i=0; $i -lt $array1.Count; $i++){
Write-Host $array1[$i] ":"$array2[$i]

}

```