.mdf to .mdb

My web host only supports .mdb database files, so is there a way to convert .mdf to .mdb with a program? Or would I have to do it by hand?

Thank you.

I am not aware that such a program exists.

Maybe you can use SQL Server DTS or SQL Server Transformation Services to download your database into a .mdb format.

|||Try to use this.
http://www.data-conversions.net/products.php?prod_num=1&&dest=MENU&&ID=100|||

I was having the same issue and followed these steps...

1. In your ODBC connections add a SQL server connection to your current SQL server and database.

2. Create a new Access Database

3. Import from ODBC source and select all tables.

The tables will import with a dbo_ prefix, but all of the structure and information will be there. It does not carry over the table relationships either.

Nick

.mdf to .mdb

My web host only supports .mdb database files, so is there a way to convert .mdf to .mdb with a program? Or would I have to do it by hand?

Thank you.

I am not aware that such a program exists.

Maybe you can use SQL Server DTS or SQL Server Transformation Services to download your database into a .mdb format.

|||Try to use this.
http://www.data-conversions.net/products.php?prod_num=1&&dest=MENU&&ID=100|||

I was having the same issue and followed these steps...

1. In your ODBC connections add a SQL server connection to your current SQL server and database.

2. Create a new Access Database

3. Import from ODBC source and select all tables.

The tables will import with a dbo_ prefix, but all of the structure and information will be there. It does not carry over the table relationships either.

Nick

..\MSSQL\Data\ - Directory saturated

C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
..ldb files that are huge, some reach 21GB! while backup files don't
exceed 8MB.

I guess it's a kind of transaction log, but I'm not sure.

Can I erase them all and lose no information?
Where I configure it to avoid it to happen in the future?

Thanks in advance.Try to shrink the database. Run the SQL Server Enterprise manager.
Right-click on the database of interest and select "all tasks | shrink
database" from the context menu. Try this witthout and then with the "move
pages" option checked. Free space "holes" can develop in your database as
storage expands and rows are added/deleted/updated. Doing index maintenance
may help, too but at 8MB vs 21GB, I'm thinking it's not just sparse page
fills but wholesale extents. You could set the databases for autoshrink but
this might cause operations in your database to slow down when you weren't
expecting it. Probably better to do it on a schedule.

You might also look at the properties and see how much space is used versus
allocated. Before looking at properties, be sure to right-click on the
database and do a "refresh" to get the figures updated.

Could be your log has never been dumped and truncated. You may have to set
up a maintenance plan. Check the Administrator's guide for advice. The log
is in the .LDF file.

"Pablo" <pablopettis@.yahoo.com> wrote in message
news:47ae7cc6.0407150630.4ad7be1d@.posting.google.c om...
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
> .ldb files that are huge, some reach 21GB! while backup files don't
> exceed 8MB.
> I guess it's a kind of transaction log, but I'm not sure.
> Can I erase them all and lose no information?
> Where I configure it to avoid it to happen in the future?
> Thanks in advance.|||Hi

Check out:
http://msdn.microsoft.com/library/d...ar_da2_1uzr.asp

If this is production machine you should think about moving the log files
onto a different set of spindles (disks/controller card) to the data files,
operating system and page file.

John

"Pablo" <pablopettis@.yahoo.com> wrote in message
news:47ae7cc6.0407150630.4ad7be1d@.posting.google.c om...
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
> .ldb files that are huge, some reach 21GB! while backup files don't
> exceed 8MB.
> I guess it's a kind of transaction log, but I'm not sure.
> Can I erase them all and lose no information?
> Where I configure it to avoid it to happen in the future?
> Thanks in advance.

*.mdb to *.sdf

Hi!
Is there any way to convert *.mdb database to *.sdf ?

Some of the tools from www.primeworks-mobile.com should be able to help you transfer your data. You could also code the conversion yourself in .NET, using the Jet OLEDB driver and the SQL CE client.|||

You can use Access Database Synchronizer (ADS) from Microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en

There are many things which you can do with this, for e.g. in addition to migrating data from a .mdb file to a .sdf file, you can also use ADS to keep them both in sync! You can also program against ADS using SqlCeRemoteDataAccess object of SQL Server 2005 Compact Edition. For details, please refer to the readme and the sample code which accompanies ADS.

HTH,

Deepesh