Solved

MDT 2008 - update deployment point database with CSV Files

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 here: http://www.experts-exchang…
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.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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