I have a connection to a database. I would like to export a database. I have tried using the SQL Import and Export wizard but it says that the ConnectionString is invalid .

I then clicked on tasks and generated a script to extract all of the schema and data, so I ended up with a .sql file.

I don't know how to open this .sql file or if this is even the database, as I just generated a script. Please guide me to what I did.