Solved

MDT 2008 - update deployment point database with CSV Files

Posted on 2009-07-15
4
532 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Know what services you can and cannot, should and should not combine on your server.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now