|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
HOW TO UPDATE DATABASE?Ussually, I make program and design database at home, then I copy it to
office's computer. But, seldom I meet problems. Example: I develope my system so I 've to make a new table at home. If I copy file *.mdf from home, so data at other tables will be loss. Altough I very need to add its table (and its data) to database to my new system can run. If I use "generate script", data will not enter. Can You give me solution so I easy to update database (add objects)? use a tool which generates scripts with data, for example QALITE.
HTH, Jens Suessmeyer. Show quote "Bpk. Adi Wira Kusuma" <adi_wira_kus***@yahoo.com.sg> wrote in message news:Ox62JVJtFHA.3476@TK2MSFTNGP14.phx.gbl... > Ussually, I make program and design database at home, then I copy it to > office's computer. But, seldom I meet problems. Example: I develope my > system so I 've to make a new table at home. If I copy file *.mdf from > home, > so data at other tables will be loss. Altough I very need to add its table > (and its data) to database to my new system can run. If I use "generate > script", data will not enter. > > Can You give me solution so I easy to update database (add objects)? > > Generate scripts for the data:
http://vyaskn.tripod.com/code/generate_inserts.txt Or there are products like Red Gate's set of tools: http://www.red-gate.com/sql/summary.htm -- David Portas SQL Server MVP -- You can use DTS to export and import data to a format such as tab delimited
text or MS Access. The good thing about Access is that you can import multiple tables in one task. Show quote "Bpk. Adi Wira Kusuma" <adi_wira_kus***@yahoo.com.sg> wrote in message news:Ox62JVJtFHA.3476@TK2MSFTNGP14.phx.gbl... > Ussually, I make program and design database at home, then I copy it to > office's computer. But, seldom I meet problems. Example: I develope my > system so I 've to make a new table at home. If I copy file *.mdf from > home, > so data at other tables will be loss. Altough I very need to add its table > (and its data) to database to my new system can run. If I use "generate > script", data will not enter. > > Can You give me solution so I easy to update database (add objects)? > > To add to JT in using access
this is the easier and economic option. My people do like this. But remember the datatypes are not same though almost similar. Dont be surprised to see float instead of int when imported back.However you can correct them without loss to data Regards R.D Show quote "JT" wrote: > You can use DTS to export and import data to a format such as tab delimited > text or MS Access. The good thing about Access is that you can import > multiple tables in one task. > > "Bpk. Adi Wira Kusuma" <adi_wira_kus***@yahoo.com.sg> wrote in message > news:Ox62JVJtFHA.3476@TK2MSFTNGP14.phx.gbl... > > Ussually, I make program and design database at home, then I copy it to > > office's computer. But, seldom I meet problems. Example: I develope my > > system so I 've to make a new table at home. If I copy file *.mdf from > > home, > > so data at other tables will be loss. Altough I very need to add its table > > (and its data) to database to my new system can run. If I use "generate > > script", data will not enter. > > > > Can You give me solution so I easy to update database (add objects)? > > > > > > >  |
|||||||||||||||||||||||
Other interesting topics