Re: Database normalization

Shwetabh wrote:
> Hi,
> I am using MS-SQL server to store my database.
> My problem is that I have around 150+ database files in DBF format.
> Each database file consists of fields ranging from 2 to 33 in number.
> Also, there are some fields which have just one entry and rest are
> NULL.
> This database will be accessed by a printing software.
> Please advice as to how I should proceed to normalize this database.
>
> Regards,
> Shwetabh

Assuming "DBF format" means xBase/FoxPro format data not in SQL Server
then I think you are asking about two different tasks.

1. Designing a data model for SQL
2. Importing the legacy data into the new model.

1. Design should proceed from business requirements to conceptual
modelling to logical modelling to physical modelling. As far as
possible that design process shouldn't be constrained by any legacy
data file format. From what you've said and based on my own experience
in the xBase/FoxPro world the existing data model won't give you many
clues about how best to implement it in SQL. On the other hand,
analysis of the data itself should be a useful way to discover
dependencies and constraints and for testing that the real data
conforms to the expected business rules. To that end you may wish
temporarily to load the data into SQL Server in a form that mirrors the
existing table structures...

2. Getting the data into SQL is the "easy" part. SQL Server DTS (in
SQL2000) or Integration Services (2005) support the DBF file format as
a data source and will help you map the old data to the new structure.
Expect to do some manipulation in Transact SQL also.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

.

Relevant Pages

  • Re: quirky stuff
    ... >>were me I'd import the the thing into SQL Server and write a stored ... > I did a few speed tests early on in this project comparing ... A decent SQL database will query a table with a million records ... binary format. ...
    (alt.comp.lang.borland-delphi)
  • Re: Sharepoint backing up
    ... You might find the database files under ... Program Files / MS SQL Server / MSSQL / Data ... What is the likely file name for the database file so I know what ... SBS 2003 installation so we know where we are. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Recovering SQL server
    ... Use your backups instead of trying to move the database files. ... the working SQL Server using sp_attach_db. ...
    (microsoft.public.sqlserver.server)
  • Re: Inserting Access 2000 Data into SQL Server 2000
    ... database which includes periodically appending new data that are provided ... others in a specificed Access 2000 format. ... way to append these data to existing tables in my SQL Server database. ...
    (microsoft.public.data.ado)
  • How to change Storage location of SSAS Database Instance
    ... SQL Server 2005 Analysis Services on W2K3 ... While creating regular databases, I know how to change the storage location of database files. ... How to change the data directory of SSAS? ...
    (microsoft.public.sqlserver.datamining)
Loading