Friday, March 9, 2012

Restoring Linux ANSI_SQL to SQL 2005

Our firm needs to analyze some financial data for a client. They gave us a SQL database file in ANSI format. Is there a way to import this data into SQL 2005?

Thanks,

Steve

If the data is in a 'standard' format, and If you have a good data map, then you 'should' be able to use SSIS, or the IMPORT Wizard, to import the data into a functioning SQL Server.|||

Arnie,

Thanks for the reply. Do I need to contact the client to get column types and widths, etc?

Steve

|||I would definitely want some way to undertand what data is in the data file, and how it is organized. So that sounds like a good plan. -Unless you can open the datafile and inspect the format.

No comments:

Post a Comment