> 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
> schema up to date, or will I have to interact with the server
> and re-create my database every time ?
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 you
created on your development machine). This is pretty easy to do in SQL
Server 7 and is more practical than using Data Transformation Services for
most purposes.
> Have you used SQL Server ? The enterprise manager looks an
> awful lot like a GUI to me :-)
SQL Server 7's GUI provides a lot more functionality than did previous
versions, although you could always build a database table-by-table in SQL
Enterprise Manager, even in earlier versions.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
