|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Visual C# Express questionI saw that in the data information box:
"you can create and deploy databases as stand-alone files, but with the powerful features unique to SQL Server 2005" And what are the installation requirement on the target computer? Is .NET 2.0 enough? Or should something else be installed as well? In which case what it is and how big the install? Lloyd,
With SQL Server Express all you need is the .NET Framework 2.0 as the database is file based and the data access components are part of the .NET Framework. -- Show quoteCarsten Thomsen Communities - http://community.integratedsolutions.dk --------- Voodoo Programming: Things programmers do that they know shouldn't work but they try anyway, and which sometimes actually work, such as recompiling everything. (Karl Lehenbauer) --------- "Lloyd Dupont" <net.galador@ld> wrote in message news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl... >I saw that in the data information box: > "you can create and deploy databases as stand-alone files, but with the > powerful features unique to SQL Server 2005" > > And what are the installation requirement on the target computer? > Is .NET 2.0 enough? > Or should something else be installed as well? In which case what it is > and how big the install? > > With SQL Server Express all you need is the .NET Framework 2.0 as the I am just about to finish a big personal project using SQLite while I could > database is file based and the data access components are part of the .NET > Framework. > Hoho..... have used SQLServerExpress instead.. :-( What do you think, should I rewrite ?! There is one feature though which is very nice in SQLite, I could define my own function (in C#), as in SELECT myFunction(Column_0), Column_1 FROM aTable; is this same functionality available in SQLServer Express? Mmh... I might staty with SQLite which is very fast and compact anyway... Show quote > -- > Carsten Thomsen > Communities - http://community.integratedsolutions.dk > --------- > Voodoo Programming: Things programmers do that they know shouldn't work > but they try anyway, and which sometimes actually work, such as > recompiling everything. (Karl Lehenbauer) > --------- > "Lloyd Dupont" <net.galador@ld> wrote in message > news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl... >>I saw that in the data information box: >> "you can create and deploy databases as stand-alone files, but with the >> powerful features unique to SQL Server 2005" >> >> And what are the installation requirement on the target computer? >> Is .NET 2.0 enough? >> Or should something else be installed as well? In which case what it is >> and how big the install? >> > > I'd stay with what you have. However, if it is a personal project, you might
want to port it to SQL Server Express, just to see the differences in implementation? There's no doubt in my mind that there will be a demand for SQL Server Express now that the Jet database has been "deprecated" by MS... -- Show quoteCarsten Thomsen Communities - http://community.integratedsolutions.dk --------- Voodoo Programming: Things programmers do that they know shouldn't work but they try anyway, and which sometimes actually work, such as recompiling everything. (Karl Lehenbauer) --------- "Lloyd Dupont" <net.galador@ld> wrote in message news:OEJesza5FHA.156@TK2MSFTNGP15.phx.gbl... >> With SQL Server Express all you need is the .NET Framework 2.0 as the >> database is file based and the data access components are part of the >> .NET Framework. >> > Hoho..... > I am just about to finish a big personal project using SQLite while I > could have used SQLServerExpress instead.. :-( > What do you think, should I rewrite ?! > There is one feature though which is very nice in SQLite, I could define > my own function (in C#), as in > SELECT myFunction(Column_0), Column_1 FROM aTable; > is this same functionality available in SQLServer Express? > > Mmh... > I might staty with SQLite which is very fast and compact anyway... > >> -- >> Carsten Thomsen >> Communities - http://community.integratedsolutions.dk >> --------- >> Voodoo Programming: Things programmers do that they know shouldn't work >> but they try anyway, and which sometimes actually work, such as >> recompiling everything. (Karl Lehenbauer) >> --------- >> "Lloyd Dupont" <net.galador@ld> wrote in message >> news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl... >>>I saw that in the data information box: >>> "you can create and deploy databases as stand-alone files, but with the >>> powerful features unique to SQL Server 2005" >>> >>> And what are the installation requirement on the target computer? >>> Is .NET 2.0 enough? >>> Or should something else be installed as well? In which case what it is >>> and how big the install? >>> >> >> > > > I'd stay with what you have. However, if it is a personal project, you right I though so.....> might > want to port it to SQL Server Express, just to see the differences in I though so as well ;-)> implementation? There's no doubt in my mind that there will be a demand > for SQL Server Express now that the Jet database has been "deprecated" by > MS... After I released it! That would be good training. That and some Avalon lifting! (It's a personal commercial project, soon to be released!) Show quote > > -- > Carsten Thomsen > Communities - http://community.integratedsolutions.dk > --------- > Voodoo Programming: Things programmers do that they know shouldn't work > but they try anyway, and which sometimes actually work, such as > recompiling everything. (Karl Lehenbauer) > --------- > "Lloyd Dupont" <net.galador@ld> wrote in message > news:OEJesza5FHA.156@TK2MSFTNGP15.phx.gbl... >>> With SQL Server Express all you need is the .NET Framework 2.0 as the >>> database is file based and the data access components are part of the >>> .NET Framework. >>> >> Hoho..... >> I am just about to finish a big personal project using SQLite while I >> could have used SQLServerExpress instead.. :-( >> What do you think, should I rewrite ?! >> There is one feature though which is very nice in SQLite, I could define >> my own function (in C#), as in >> SELECT myFunction(Column_0), Column_1 FROM aTable; >> is this same functionality available in SQLServer Express? >> >> Mmh... >> I might staty with SQLite which is very fast and compact anyway... >> >>> -- >>> Carsten Thomsen >>> Communities - http://community.integratedsolutions.dk >>> --------- >>> Voodoo Programming: Things programmers do that they know shouldn't work >>> but they try anyway, and which sometimes actually work, such as >>> recompiling everything. (Karl Lehenbauer) >>> --------- >>> "Lloyd Dupont" <net.galador@ld> wrote in message >>> news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl... >>>>I saw that in the data information box: >>>> "you can create and deploy databases as stand-alone files, but with the >>>> powerful features unique to SQL Server 2005" >>>> >>>> And what are the installation requirement on the target computer? >>>> Is .NET 2.0 enough? >>>> Or should something else be installed as well? In which case what it is >>>> and how big the install? >>>> >>> >>> >> >> > > > With SQL Server Express all you need is the .NET Framework 2.0 as the What mean by "database is file based"?> database is file based and the data access components are part of the .NET Like MS Access; not service/server based...
"Easily move or copy your SQL Server Express databases to another computer or hosted server using XCopy and ClickOnce deployment." an excerpt taken from here: http://msdn.microsoft.com/vstudio/express/sql/ -- Show quoteCarsten Thomsen Communities - http://community.integratedsolutions.dk --------- Voodoo Programming: Things programmers do that they know shouldn't work but they try anyway, and which sometimes actually work, such as recompiling everything. (Karl Lehenbauer) --------- "William Stacey [MVP]" <william.sta***@gmail.com> wrote in message news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl... >> With SQL Server Express all you need is the .NET Framework 2.0 as the >> database is file based and the data access components are part of the >> .NET > > What mean by "database is file based"? > Think your talking about the User Instance feature. It is still service
based, but is a short-cut to automaticaly create the instance and load the db. After that, it is pretty much like accessing a shared instance using shared memory. However the restriction is that it is single user based so not sharable and the user can admin the thing without being admin. It is pretty cool way to go if you just need a db for your single user app. -- Show quoteWilliam Stacey [MVP] "CT" <carstent@spammersgoawayintegrasol.dk> wrote in message news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl... > Like MS Access; not service/server based... > > "Easily move or copy your SQL Server Express databases to another computer > or hosted server using XCopy and ClickOnce deployment." an excerpt taken > from here: http://msdn.microsoft.com/vstudio/express/sql/ > > -- > Carsten Thomsen > Communities - http://community.integratedsolutions.dk > --------- > Voodoo Programming: Things programmers do that they know shouldn't work > but they try anyway, and which sometimes actually work, such as > recompiling everything. (Karl Lehenbauer) > --------- > "William Stacey [MVP]" <william.sta***@gmail.com> wrote in message > news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl... >>> With SQL Server Express all you need is the .NET Framework 2.0 as the >>> database is file based and the data access components are part of the >>> .NET >> >> What mean by "database is file based"? >> > > > Think your talking about the User Instance feature. It is still service uh.. was CT wrong when he told me the .NET framework was all that's > based, but is a short-cut to automaticaly create the instance and load the is it? required? I'll try for fun but SQLite seems a much better way to go in my case then. Show quote > db. After that, it is pretty much like accessing a shared instance using > shared memory. However the restriction is that it is single user based so > not sharable and the user can admin the thing without being admin. It is > pretty cool way to go if you just need a db for your single user app. > > -- > William Stacey [MVP] > > "CT" <carstent@spammersgoawayintegrasol.dk> wrote in message > news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl... >> Like MS Access; not service/server based... >> >> "Easily move or copy your SQL Server Express databases to another >> computer or hosted server using XCopy and ClickOnce deployment." an >> excerpt taken from here: http://msdn.microsoft.com/vstudio/express/sql/ >> >> -- >> Carsten Thomsen >> Communities - http://community.integratedsolutions.dk >> --------- >> Voodoo Programming: Things programmers do that they know shouldn't work >> but they try anyway, and which sometimes actually work, such as >> recompiling everything. (Karl Lehenbauer) >> --------- >> "William Stacey [MVP]" <william.sta***@gmail.com> wrote in message >> news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl... >>>> With SQL Server Express all you need is the .NET Framework 2.0 as the >>>> database is file based and the data access components are part of the >>>> .NET >>> >>> What mean by "database is file based"? >>> >> >> > > Yes, I was wrong. SQL Server Express must be installed on the destination
computer. However, if that is the case, you can use Xcopy deployment. Thanks for clearing that up William. :-) -- Show quoteCarsten Thomsen Communities - http://community.integratedsolutions.dk --------- Voodoo Programming: Things programmers do that they know shouldn't work but they try anyway, and which sometimes actually work, such as recompiling everything. (Karl Lehenbauer) --------- "Lloyd Dupont" <net.galador@ld> wrote in message news:esE3%235c5FHA.476@TK2MSFTNGP15.phx.gbl... >> Think your talking about the User Instance feature. It is still service >> based, but is a short-cut to automaticaly create the instance and load >> the > is it? > uh.. was CT wrong when he told me the .NET framework was all that's > required? > > I'll try for fun but SQLite seems a much better way to go in my case then. > > >> db. After that, it is pretty much like accessing a shared instance using >> shared memory. However the restriction is that it is single user based >> so not sharable and the user can admin the thing without being admin. It >> is pretty cool way to go if you just need a db for your single user app. >> >> -- >> William Stacey [MVP] >> >> "CT" <carstent@spammersgoawayintegrasol.dk> wrote in message >> news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl... >>> Like MS Access; not service/server based... >>> >>> "Easily move or copy your SQL Server Express databases to another >>> computer or hosted server using XCopy and ClickOnce deployment." an >>> excerpt taken from here: http://msdn.microsoft.com/vstudio/express/sql/ >>> >>> -- >>> Carsten Thomsen >>> Communities - http://community.integratedsolutions.dk >>> --------- >>> Voodoo Programming: Things programmers do that they know shouldn't work >>> but they try anyway, and which sometimes actually work, such as >>> recompiling everything. (Karl Lehenbauer) >>> --------- >>> "William Stacey [MVP]" <william.sta***@gmail.com> wrote in message >>> news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl... >>>>> With SQL Server Express all you need is the .NET Framework 2.0 as the >>>>> database is file based and the data access components are part of the >>>>> .NET >>>> >>>> What mean by "database is file based"? >>>> >>> >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics