Difference between InitialCatalog and Database Name

2.3k views Asked by At

I'm amidst "parameterizing" a connection in my package and I'm confused: I'm trying to set the database name but there are two options: 1- InitCatalog Name and 2- Name:

Here is what my connection looks like: enter image description here

And my parameter options are (as mentioned 1- InitCatalog Name and 2- Name): enter image description here and enter image description here

So my question is: which one do I choose? I've read about "InitCatalog" and it seems to be where you'd define the default database within a server. But that could be defined under the name as well. Thank you!

1

There are 1 answers

1
HDD On

As answered here: Difference between Initial Catalog and Database keyword in connection string

The only difference is the name.