Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MDT 2008 - update deployment point database with CSV Files

Posted on 2009-07-15
4
Medium Priority
?
542 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

660 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