I am currently creating a database for my project and was wondering where I should save the table. Should I just save it in documents (D:\Documents) or should I save it in the same folder where my project is saved (D:\Documents\Visual Studio 2015\Projects\ALevelCompUnit3)? I was hoping to develop it at school.
我目前正在为我的项目创建一个数据库,并想知道我应该在哪里保存表。我应该将其保存在文档(D:\ Documents)中,还是应该将其保存在保存项目的同一文件夹中(D:\ Documents \ Visual Studio 2015 \ Projects \ ALevelCompUnit3)?我希望在学校开发它。
Also, the school only provides Visual Basic 2008; would I have to change the framework to do it at school?
此外,学校只提供Visual Basic 2008;我是否必须改变框架才能在学校完成这项工作?
1 个解决方案
#1
-1
SQL Server Express in fact is a light weight version of the SQL server engine that is stored locally on your file system under the extension .mdf. Within this file you will be saving things like tables, views and stored procedures. You can move this file around similar to other traditional file types and where you store it while your developing your application is up to you. If, and when you application grows you may consider moving it over to a full version of SQL Server and there are tools to quickly migrate over. In regards to your Visual Studio versions - Using 2015 at home and switch over to 2008 at school will be a little painful. There are many features of 2015 that are not available in 2008. You should be able to access the .mdf file but your experience will not be as powerful in terms of capabilities.
SQL Server Express实际上是SQL服务器引擎的轻量级版本,它在本地存储在扩展名为.mdf的文件系统上。在此文件中,您将保存表,视图和存储过程等内容。您可以将此文件与其他传统文件类型相似,并在您开发应用程序时由您来存储它。如果,当您的应用程序增长时,您可以考虑将其移至完整版本的SQL Server,并且有快速迁移的工具。关于您的Visual Studio版本 - 在家中使用2015并在学校切换到2008将会有点痛苦。有许多2015年的功能在2008年不可用。您应该能够访问.mdf文件,但您的体验在功能方面不会那么强大。
#1
-1
SQL Server Express in fact is a light weight version of the SQL server engine that is stored locally on your file system under the extension .mdf. Within this file you will be saving things like tables, views and stored procedures. You can move this file around similar to other traditional file types and where you store it while your developing your application is up to you. If, and when you application grows you may consider moving it over to a full version of SQL Server and there are tools to quickly migrate over. In regards to your Visual Studio versions - Using 2015 at home and switch over to 2008 at school will be a little painful. There are many features of 2015 that are not available in 2008. You should be able to access the .mdf file but your experience will not be as powerful in terms of capabilities.
SQL Server Express实际上是SQL服务器引擎的轻量级版本,它在本地存储在扩展名为.mdf的文件系统上。在此文件中,您将保存表,视图和存储过程等内容。您可以将此文件与其他传统文件类型相似,并在您开发应用程序时由您来存储它。如果,当您的应用程序增长时,您可以考虑将其移至完整版本的SQL Server,并且有快速迁移的工具。关于您的Visual Studio版本 - 在家中使用2015并在学校切换到2008将会有点痛苦。有许多2015年的功能在2008年不可用。您应该能够访问.mdf文件,但您的体验在功能方面不会那么强大。