有一些生成数据库的脚本文件,要做个程序来通过这些脚本生成数据库。即可以在本机生成,又能在局域网中的其他机上生成。不知道有没有做过这的朋友给些源码看看啊。
解决方案 »
- C# WINFROM 界面仿PAD 隐藏 显示动画 问题?
- KeyCode的用法
- fixed 语句
- 导出Excle到DataGrid时某几列数据无法导出
- javascript怎么判断一个值为null
- 关于c#的相关问题
- c#怎么解析soap调用webservice返回的xml格式的字符串
- 如何在web的FORM1模式下画一条线段
- 如何压缩jpeg图片文件存储的质量,就像图片减肥软件一样。
- 低价出让vs7正式版,偶有一套vs7(Englist)及急欲转让(5CD),有意请进...
- 如何将一个xml的string读到dataset中?
- 在C#里如何画一个立体长方体,不要填充,只要线框就行?(winform)
@echo offIF "%1"=="" GOTO usage@echo.
@echo. Building Duwamish 7 Database...
@echo.@echo.
@echo. Creating Tables...
@echo.
osql -E -d %1 -n -i d7_tables.sql
@echo.
@echo. Creating Stored Procedures...
@echo.
osql -E -d %1 -n -i d7_sprocs.sqlosql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetAddressByCustomerId] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCategories] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerById] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerByEmail] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByAuthor] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByCategoryId] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBookById] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByISBN] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksBySubject] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByTitle] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertAddress] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomerAddress] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertCustomer] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetail] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetailsByList] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertSale] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomer] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[PopFirstWord] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetDailyPickBooksByCategoryId] TO [%1]"
@echo.
@echo. Loading Data...
@echo.
bcp %1..ItemType in ItemType.bcp -E -T -w
bcp %1..ItemCategory in ItemCategory.bcp -E -T -w
bcp %1..Categories in Categories.bcp -E -T -w
bcp %1..Items in Items.bcp -E -T -w
bcp %1..DailyPick in DailyPick.bcp -E -T -w
bcp %1..Books in Books.bcp -E -T -w
bcp %1..Authors in Authors.bcp -E -T -w
bcp %1..BookAuthor in BookAuthor.bcp -E -T -w
bcp %1..Publishers in Publishers.bcp -E -T -w
bcp %1..Customers in Customers.bcp -E -T -w
bcp %1..Addresses in Addresses.bcp -E -T -w@echo.
@echo. Completed!
@echo.
GOTO :EOF:usage
echo.
echo. Usage: Setup [D7 : Duwamish 7 Database Name]
echo. : Database must already exist.
echo. Desc: Create Tables,
echo. : Stored Procedures,
echo. : Loads Duwamish Data
echo.
上面的代码要求运行该代码的机器安装有SQLSERVER,如果没有安装不了.可以直接使用SqlCommand对象来执行命令建立脚本string sqltext="create table ...."//这里可以放所有脚本
SqlCommand com=new SqlCommand(sqltext,conn);
com.ExecuteNoQuery().
不知道C#里面有没有可以直接运行脚本文件的方法?