Hi all,
up to now I have had the pleasure of only needing to use Access databases for
our CF projects, however a possible upcoming task and at least one of the since much
larger completed tasks will soon require the power of a database server, at this point
in time, MS SQL Server.
Your gonna be needing to do some reading up on database servers before you
embark on this methinks.
There is a big difference between an Access database file and SQL Server. A
database server does not have separate files like Access, the database are
self-contained within the server itself.
On Tue, 16 May 2000 00:02:17 +0100, Russ Michaels [EMAIL PROTECTED] wrote:
Your gonna be needing to do some reading up on database servers before you
embark on this methinks.
I am a BSc. with a CS major, one of my final courses was for the most part made up of
studying SQL in Ingres, so I
Correct, but different servers will do things differently, SQL server (so
far as I can see) stores a database in two seperate files once created -
.mdf and .ldf (data and transaction log files), my question is can I just
replace these files with newer versions to bring the remote database
Correct, but different servers will do things differently,
SQL server (so far as I can see) stores a database in two
seperate files once created - .mdf and .ldf (data and
transaction log files), my question is can I just replace
these files with newer versions to bring the remote database
I don't think you can simply overwrite these files safely, as metadata for
the databases is stored in the master database. At least, that's how it
works in earlier versions. If you can shut down any database clients (like
CF) during the process, you can restore from a backup device file (that
This is true the master db does contain info about the DB
including the security settings and things like that. But I
think as long as the services are stopped then there should
not be a problem.
Again I am not sure because the only thing I have done it
with was a small static DB but it is
On Mon, 15 May 2000 22:42:36 -0400, "Dave Watts" [EMAIL PROTECTED] wrote:
seperate files once created - .mdf and .ldf (data and
I don't think you can simply overwrite these files safely, as metadata for
the databases is stored in the master database. At least, that's how it
works in earlier
8 matches
Mail list logo