Solved

MDT 2008 - update deployment point database with CSV Files

Posted on 2009-07-15
4
535 Views
Last Modified: 2013-11-21
I have just rebuilt our deplyment server - before wiping the old server which had bdd 2007 installed - I exported the deploment database repsository to CSV files
So all the information that was stored for Computers, roles, locations. make and models are in CSV files

I have rebuilt the server and installed MDT 2008 which is the new and improved BDD
I have setup everything including the SQLEXPRESS database to store the repository
but there is no option to import the formerly exported CSV files

Is there anyway to do this - either in MDT or in SQL inself?

0
Comment
Question by:TED_UBB
  • 3
4 Comments
 
LVL 10

Expert Comment

by:JonLambert
ID: 24864926
Hi,

I faced this issue awhile back so I've created a script to do the import into BDD 2007/MDT from a BDD 2.5 export.

Edit the User configurable variables at the beggining of the script, as well as the values in the INI file (INI file and import file must be in the same directory as the script).

I haven't used this in a long time, so let me know if you have any issues. (you will have to rename ImportIntoBDD2007 from .txt to VBS, and the BDD2007migration file from .txt to .INI


ImportIntoBDD2007.txt
BDD2007MIGRATION.txt
0
 

Accepted Solution

by:
TED_UBB earned 0 total points
ID: 24936072
Hi,
Does the above script also import all the setting that are included with each entry in the old database - I think they only migrate the names in the CSV
I think the best thing for me to do is to re-image the server with an snapshot of the old BDD 2007 - backup the BDD database - then re-image the server with a snapshot from last week which has the new MDT software installed and restore the database into the the MDT installation
Thanks for your help
Ted
0
 
LVL 10

Expert Comment

by:JonLambert
ID: 24941038
Nope it migrates all fields in the CSV .. I've used this script to do two BDD 2.5 to BDD 2007/MDT migrations
0
 
LVL 10

Expert Comment

by:JonLambert
ID: 24941047
Upon re-reading the question .. this script ONLY migrateds computer settings, not roles,locations and Make/Model. So my apologies.  This script imports all fields for the computer settings only.

That being said, re-doing the roles, locations and make/model shouldn't take long by hand, as (in all the instances I've seen) they usually don't contain that much data.

However, if you do have a backup, that may be the easiest option.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question