Re: How to copy a database?
- From: Jéjé <willgart@xxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 22:09:33 -0400
if you have access to the database, you can copy it or you can use the import wizard.
if you just have access to the flat files, then you have to import these files (again using the import wizard or directly by created DTS packages)
in this case you have to create the tables with the right column types (varchar, int ... primary key...)
also you have to check the network speed. other a slow network, copying a ZIP file (which contain the flat files) could help you.
some optimizations could be used, like transfering only new data if you have to load frequently the info.
"Helma S via SQLMonster.com" <forum@xxxxxxxxxxxxxx> wrote in message news:539B3F1548E80@xxxxxxxxxxxxxxxxx
The ministery of Education is developing a datawarehouse. As a result they
can deliver Ascii files or facttables and dimensiontables. Statistics
Netherlands is allowed to make use of their figures. Is it possible to make a
full copy of their database or should we ask the ascii file so that we can
create facttables and dimensiontables by our own. Maybe it depends on the
frequency of delivering but I hope that you can give me some advise.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-warehouse/200508/1
.
- Next by Date: Select And Insert
- Next by thread: Select And Insert
- Index(es):
Relevant Pages
|
