|
You’re correct Conor, but there are often
issues as the database retains the original security settings and unless the
client environment is compatible you can spend hours on the phone to the client
tweaking things to make the data available. We script the structures and data out to a
SQLscript which can create the database and tables if required and then update
or insert the rows. A little more trouble, but it makes installation and
maintenance of common data across the clients a snip. If written
carefully it can be db independent which allows operation across a wide range
of environments (MSSQL, Ingres, Sybase, Oracle, …..) $0.02 Stephen From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] You can use the Enterprise Manager tool to
create a backup of a database. Then use the same tool at your client to
restore the database. I use this all the time to copy databases
between servers. Works a treat. SQL Server 2000, but I suppose there's
something similar in any version. Not sure what you mean by removable
database, I'm afraid. HTH, Conor From:
Jeremy Coulter [mailto: Just following on from my question yesterday, one of
the things we are going to want to do is distribute an MSSQL db to the
customer. We need to do this as appossed to just creating the database and
tables on the fly, is that a couple of tables need pre-populated data in them. I know you can create a "Removable Database" in
MSSQL, which pretty much takes a copy of the database with out detaching it
from the original SQL Server...I think thats how it works. I will then just re attach it, although I need to
investigate this bit some more. Anyone do anything like this now?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
_______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
