SQL Server How to export a database we have a connection to?

zpqajqem 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(100)

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.

sql-server

来源：https://stackoverflow.com/questions/76637975/how-to-export-a-database-we-have-a-connection-to

1条答案

按热度按时间

bvpmtnay1#

.sql format is text format, any text editor should be able to open it. Also, Sql Server Management Studio (SSMS) should be able to open it.

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server How to export a database we have a connection to?

1条答案

相关问题

热门标签

最新问答