如何使用网页将数据库附加到sqlserver [英] How to attach database to sqlserver using web page

问题描述

我必须从DataContext（dbml）创建一个新数据库并将其附加到sqlserver

我创建了新数据库但是附加方法不起作用



我的尝试：

I have to create a new database from DataContext (dbml) and attach it to sqlserver
I have created the new database but the attach method doesn't work

What I have tried:

 MyDataContext db = new MyDataContext (connstr);
            db.CreateDatabase();
            System.Diagnostics.Process process = new System.Diagnostics.Process();
            System.Diagnostics.ProcessStartInfo startInfo = new                                                                                        System.Diagnostics.ProcessStartInfo();
            startInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
            startInfo.FileName = "cmd.exe";
            startInfo.Arguments = "sqlcmd -S localhost\\SQLexpress"+ Environment.NewLine +
"USE [master]"+ Environment.NewLine +
"GO"+ Environment.NewLine +
"CREATE DATABASE MyNewDb ON "+ Environment.NewLine +
"( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.mdf' ),"+ Environment.NewLine +
"( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.ldf' )"+ Environment.NewLine +
" FOR ATTACH ;"+ Environment.NewLine +
"GO";
            process.StartInfo = startInfo;
            process.Start();
            process.WaitForExit();

推荐答案

（FILENAME = N'C：\\Program Files \\\ \\ _Microsoft SQL Server \\MSSQL10_50.SQLEXPRESS \\MSSQL \\DATA \\ MyNewDb.ldf'）



查看两者的扩展名第一项是mdf而另一项是ldf

( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.ldf' )

Check Extensions of both items one is mdf and other is ldf

这篇关于如何使用网页将数据库附加到sqlserver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！