ETL and Data Integration tools - Modern ETL software for everyone

I have a database file with the extension "mdf" , I can connect, but, the software do not give any information about tables, procedures or views that exist in this file,

How I do to connect and retrieve these information? Somebody has a idea? Any suggestion is very important for me!

Thanks a lot,
wbidin

Which kind of database are you talking about?

Oracle, SQL Server, Interbase ETC?

Peter

Hi Peter,

I'm using the SQLExpress, and I didn't write it, because I thought that this extension was exclusive for this database.

Sorry for this error.

It is not possible to connect to mdf file directly.
You have to connect to SQLExpress

Peter

Peter,

in my job, we do not have permission to create a db's in SQL Express, and I do not know attach this mdf in SQL Express (well, I do not know if it is possible too).

You have any suggestion, or know if, the tool has support a connection with Firebird embedded, this would be a other option.

Thanks a lot,

This will attach the database

USE [master]
GO
CREATE DATABASE [database_name] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.ldf' )
FOR ATTACH ;
GO

Peter