MS SQL Data Warehousing - How to copy a database?

Author

How to copy a database?

Helma S via SQLMonster.com

2005-08-30, 3:23 am

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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ehouse/200508/1

Jéjé

2005-09-01, 3:23 am

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 webservertalk.com" <forum@webservertalk.com> wrote in message
news:539B3F1548E80@w
ebservertalk.com...
> 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 webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...ehouse/200508/1

Sponsored Links