Devam Ediyor

Convert MDB to MDF file

We develop an asset tracking software program called AssetManage.? We have a version that uses a Microsoft Access 2000 data file and another version that uses ODBC to connect to the back-end database.? The database table formats for both products are very similar but not identical.

A customer needs to have an MDB file with their data converted to SQL Server 2000 MDF format, this requires converting the MDB to an MDF and making a few fieldname changes so that it works with our ODBC version.

You will need SQL Server 2000 running to be able to setup the database using the MDF file you converted, then setup an ODBC connection to it using the Windows ODBC Administrator.

To test, simply download the AssetManage Enterprise program from:

[url removed, login to view]

Then attach your converted MDF file to an SQL Server 2000 database, run the program and select an ODBC data source.? If the program runs, you can add, edit records, then the file has been converted properly.?

The Schema for the Enterprise version can be found at:

<[url removed, login to view]>

We will have similar projects like this come up every few weeks and if this works out, will be glad to post them again on RentACoder with you as the preferred coder.

## Deliverables

The MDB file to be converted is in the Attached Zip file.

To see all the changes that need to be made you must compare the MDB file with the schema for the MDF file.? Please note that when you install the AssetManage Enterprise demo, you will find an empty MDF file with the proper database strucutre that may be useful, it is in the [\\Program][1] Files\AssetManage Enterprise\UPSIZE folder.

Here are some of the changes that will need to be made:

1/ Convert the 'LSS~OurHouse' tablename to 'Assets'

2/ In the Assets folder, change the following fieldnames:

ID >> AssetId

Size >> ItemSize

?

[DepreciationInfo]

?

ID >> DepID

?

[DepreciationMethods]

?

ID >> MethodID

?

[FieldNames]

?

ID >> FieldID

Beceriler: Mühendislik, Microsoft Access, MySQL, PHP, Yazılım Mimarisi, Yazılım Test Etme, SQL

Daha fazlasını görün: convert access file mdf file, convert mdb mdf, mdb mdf, mdf mdb, convert mdb file mdf format, convert mdf database mdb, program convert mdb file mdf, mdf mdb odbc, converting mdb file mdf, software convert mdf file mdb, convert mdb mdf format, convert mdb mdf database software, convert mdb file mdf file, www rentacoder net, rentacoder come, mdb files, find a database administrator, enterprise products, data strucutre, convert file to, convert $50, connection tracking, convert mdf mdb database, microsoft access test, sql server database administrator

İşveren Hakkında:
( 20 değerlendirme ) Mississauga, Canada

Proje NO: #3910485

Seçilen:

mkamaleg2000vw

See private message.

14 gün içinde 68$ USD
(120 Değerlendirme)
5.4

10 freelancers are bidding on average $51 for this job

smartdatasoft

See private message.

in 14 gün içinde34$ USD
(120 Değerlendirme)
5.7
Wonderer

See private message.

in 14 gün içinde85$ USD
(69 Değerlendirme)
5.6
NeoNoXtraOrdnry

See private message.

in 14 gün içinde34$ USD
(80 Değerlendirme)
5.5
mdkass

See private message.

in 14 gün içinde85$ USD
(49 Değerlendirme)
5.2
wwwstandards

See private message.

in 14 gün içinde42.5$ USD
(21 Değerlendirme)
3.7
sicere

See private message.

in 14 gün içinde42.5$ USD
(5 Değerlendirme)
2.2
vw7252524vw

See private message.

in 14 gün içinde42.5$ USD
(1 Değerlendirme)
0.0
kumaryashvw

See private message.

in 14 gün içinde57.8$ USD
(1 Değerlendirme)
0.0
inventinsol

See private message.

in 14 gün içinde21.25$ USD
(1 Değerlendirme)
0.9