I am working on a C# application which depends on a few SQL Server databases. Now, in my development environment, I am using SSMS (SQL Server Management Studio) to create and manage my databases. My connection string looks like this:
SQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=mySQLServerDBName;" & _ "User ID=myUsername;" & _ "Password=myPassword"
I am not sure how to properly ask the question. The point is, how do I provide the databases then? I mean:
Should I backup my databases, ask the client to install both SQL Server instance and SSMS, then restore the databases from SSMS?
Should I provide my databases and ask the client only to install SQL Server instance? In this case, how should they restore the databases?
Please, I am not very experienced, that's why I am asking.