SolidWorks 手动安装 Sql Server 及数据库手动添加步骤

1. 安装免费版sql server 2019 express 

地址:https://download.microsoft.com/download/7/f/8/7f8a9c43-8c8a-4f7c-9f92-83c18d96b681/SQL2019-SSEI-Expr.exe

2 拷贝就的solidworks mdf ldf数据库文件到 DATA目录

3.每个数据库运行数据库附加命令

EXEC  sp_attach_db  @dbname  =  'tew_app_data',     

@filename1  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_data.mdf',     

@filename2  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_data_log.ldf'

 

EXEC  sp_attach_db  @dbname  =  'tew_app_macro',     

@filename1  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_macro.mdf',     

@filename2  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_macro_log.ldf'

 

EXEC  sp_attach_db  @dbname  =  'tew_app_project',     

@filename1  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_project.mdf',     

@filename2  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_app_project_log.ldf'

EXEC  sp_attach_db  @dbname  =  'tew_catalog',     

@filename1  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_catalog.mdf',     

@filename2  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_catalog_log.ldf'

 

EXEC  sp_attach_db  @dbname  =  'tew_classification',     

@filename1  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_classification.mdf',     

@filename2  =  'M:\\work\\tool\\SolidWorks2022Portable\\MSSQL15.TEW_SQLEXPRESS\\MSSQL15.TEW_SQLEXPRESS\\MSSQL\\DATA\\tew_classification_log.ldf'

4.打开SOLIDWORKS Electrical应用程序设置(工具 > 应用程序设置),设置好数据库安装时填的密码,数据库实例名称.
 

数据库添加完成后免安装绿色版solidworks Electrical就可以用了.

还有要在solidworks Electrical 工具 数据库