Showing posts with label mdb. Show all posts
Showing posts with label mdb. Show all posts

Saturday, February 25, 2012

convert or transfer access mdb file to sql server

what's the easiest way to do this. i have 5 tables within the mdb file
i tried the "easiest way" shown in a website but it does not work.
the way i did it was on access(2007) > database tools tab > sql server button
it gave me an error when it ask for an login ID
i do not have any password/id..

please help
thanksIf you do not have a logon to the SQL server then you do not have the permissions to do anything to it - simple eh?|||He could be set up with windows authentication or mixed-mode security, which would not require a password.|||it's microsoft sql server management
when i open it.
it will show a box to connect.

server type is Database Engine
Server name is Mackenzo
auth. is windows auth

yes i have a username without a password which is mackenzo/mackenzie

what can i do??

Friday, February 24, 2012

Convert MS Access(*,mdb) to SQL Server Database

Hi

I need to convert on existing Access database to SQL Server database. If I convert though sql DataTransformation, it taking only data from the Acccess Database not all the constraints like Primary Key, Default Value, Relations .........

Any one can give the solution to this

-->nRk

DTS and SSIS are both about moving data, they are not migration tools themselves, so they do not care about structural elements.

There seem to be plenty of guides and such like online-

http://www.microsoft.com/sql/solutions/ssm/access/accessmigration.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx?mfr=true

http://www.mssqlcity.com/FAQ/General/MigFromAcc.htm

convert mdf to mdb

hi all,

I'm using visual web developer and created a project with a mdf data file. how can I convert this file to MS ACCESS mdb file?

Thanks

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

|||

I just installed Visual Web Developer and SQL Server 2005 Express Edition. Seems cannot find the tool you mentioned..

If programatically convert it I'm concerning some reserved words problem like "Value" in SQL server is ok while ion ACCESS is a reserved word..

And DateTime in SQL is one field while in ACCESS is in 2 fields..

|||

Hi stardust25,

TATWORTH :

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

The solution TATWORTH has suggested you should work on SQL Server 2005. But since you haveExpression Edition installed, things are a little different.Based on my understanding, SQL Express doesnot have DTS/SSIS shipped with. We can only useBCP, Bulk Insert, Openrowset, Code..etc to do export/export (based on the datatype you want to deal with). You can take a look at this thread I answered recentlyhttp://forums.asp.net/t/1139369.aspx, I hope it can help you better understand the converstion process.thanks

Tuesday, February 14, 2012

Convert from Clarion to MS SQL Server or Access

Hello!

Somebody knows how to convert the data from Clarion (tps) to mdb or mdf files?
Any variants?

Thanks to all!

I don't know much about Clarion, well, nothing.
There seems to be plenty of ODBC drivers for it though.
You could then use SSIS to import the data into SQL. You cannot as such "convert" anything to mdf. You can import it into SQL though.

http://www.google.co.uk/search?q=clarion+odbc+drivers&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB213GB213|||Crispin, thanks for the time, given to my question.

Convert from Access to SQL Server

Can I convert .MDB file to SQL Server database or I need to develop SQL
server database from begin, every table, every field?Can I convert .MDB file to SQL Server database or I need to develop

Quote:

Originally Posted by

SQL server database from begin, every table, every field?


You can choose.

You can "convert" an MDB (definition + data) to a SQL server database either
using "Upsize Wizard" or "SQL Server Migration Assistant for Access".
You can manually create a new SQL server database via "SQL Server Management
Studio".

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution|||Igor wrote:

Quote:

Originally Posted by

Can I convert .MDB file to SQL Server database or I need to develop SQL
server database from begin, every table, every field?


Access has an Upsizing Wizard that will port the table structures and
the data to SQL Server.

The problem is that many Access databases aren't designed for the SQL
DBMS model. So performing a simple migration isn't necessarily going to
give you a sensible or even workable solution in SQL Server. Also, the
migrated database typically may not perform well unless you redesign
some of the logic to take advantage of server-side execution and stored
procedures.

For these reasons I would recommend you view the Upsizing Wizard as
just one step in the process. You should still review the logical
design and you should probably assume that some re-design will be
necessary. Re-writing to use TSQL stored procs should also be an
essential part of the migration.

If you don't make the effort to do these things then the end result
won't be as effective as it could be. In that case you may even be
better sticking with Access until you are able to do the job properly.

--
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/...US,SQL.90).aspx
--

Convert from .sdf file to .mdb file

Hellow

I have an application that builds a .sdf Sqlq Server Compact Edition file I want to view the file on a desktop computer How can I do it ?

If there is no simple way to do this how can I write a C# application to convert the .sdf file to .mdb file so I will be able to use Microsoft Access to view it.

Thanks

Ofer

You can connect to your SQL Compact Edition database using SQL Server 2005 Management Studio or Visual Studio 2005 SP1. If you need to convert from .SDF to MS Access (or vice-versa), check out the Data Port Wizard tool from one of the other MVPs, JP Figueroa:

http://www.primeworks-mobile.com/

Regards,

Darren Shaffer

|||

You can also try SQL Server Express edition if you do not have SQL Server 2005.

Cheers

Jeba