SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 08/13/2002 :  13:06:53  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
SQL Novice writes "I'm trying to find a good way to store SQL Server 7 data in sometype of physical storage preferably CD-ROM. The database itself is 3 Gb large. I would like to break this database into small chunks - by periods of time and big enough to fit in CDs.

My idea - I'd do that by exporting my SQL database to Microsoft Access in dated chunks and then store the ".mdb" file in CD. This way, each of these CDs could be accessed or queried upon from any computer that has Access in it. All I will need in future is to be able to access the data and generate reports. Is this idea good? Could you suggest a better option?

Also, I tried exporting it to Access 97 database using DTS but the export only succeeds in creating the exported tables but fails to export the data inside these tables. The error on some of them is "Timed out" or "Database is already open .. one user at a time". What am I doing wrong?

Thanks!"

setbasedisthetruepath
Used SQL Salesman

USA
992 Posts

Posted - 08/13/2002 :  14:18:59  Show Profile  Reply with Quote
quote:

SQL Novice writes "I'm trying to find a good way to store SQL Server 7 data in sometype of physical storage preferably CD-ROM. The database itself is 3 Gb large. I would like to break this database into small chunks - by periods of time and big enough to fit in CDs.

The larger question is why? Placing a 3Gb database onto a series of 650 Mb CD's is not going to produce online storage, if that's what you're after. And I don't follow what advantages are present by converting the data to an Access database.

There are a number of avenues to approach this problem, from DTS to creative filegroup management to partitioned views. Give us a description of the business problem and we can help you out further.

Jonathan Boott, MCDBA
{0}
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000