Transform data to a new structure

Posted by rAyt on Server Fault See other posts from Server Fault or by rAyt
Published on 2010-03-29T13:12:50Z Indexed on 2010/03/29 13:13 UTC
Read the original article Hit count: 421

Filed under:

mssql

|

tools

|

msaccess

Hi, I've got an Access database from one of our clients and want to import this data into a new MSSQL Server 2008 database structure I designed. It's similar to the Access Database (including all the rows and so on) but I normalized the entire database.

Is there any tool (microsoft tools preferred) to map the old database to my new design?

thanks

© Server Fault or respective owner

Related posts about mssql

Fixing my SQL Directory NTFS ACLS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after… >>> More
Restore Database from MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Recover Data Entered in MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Plans for our next milestone

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have seen some increase in activity with more people downloading our driver and either reporting their successes or reporting any issues they run into – for the native driver (sqlsrv_xxxx API) to the PDO driver (PDO API). We’d like to thank you all for your effort and hope that our… >>> More
SQL Server Driver for PHP 2.0 CTP2 is now released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
digg_url = "http://blogs.msdn.com/b/sqlphp/archive/2010/06/15/sql-server-driver-for-php-2-0-ctp2-is-now-released.aspx";digg_title = "SQL Server Driver for PHP 2.0 CTP2 is now released";digg_bgcolor = "#FFFFFF";digg_skin = "normal"; digg_url = undefined;digg_title… >>> More

Related posts about tools

java.lang.IllegalAccessException during Ant jwsc webservice build

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I have a large application, part of which relies on a set of 3 webservices. I'm currently in the process of writing an Ant build script to build and package the application into an EAR file. When building the web sub-project for this application I use the <jwsc> task in Ant to compile… >>> More
juju bootstrap fails with a local environment, why?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Each time I try to bootstrap juju using a local enviroment it fails starting the juju-db-braiam-local script as follows: $ sudo juju --debug --verbose bootstrap 2013-10-20 02:28:53 INFO juju.provider.local environprovider.go:32 opening environment "local" 2013-10-20 02:28:53 DEBUG juju.provider.local… >>> More
How to stop an IOException error using whilst using a combination of jython, pyro and ant?

as seen on Stack Overflow - Search for 'Stack Overflow'
So the wonderful low down on this doozie of a problem: short version: We are building a distribution system for this item of software we're using. Basically we take out build artifact, store it on an ftp server which passes it to multiple clients which execute scripts to patch their servers. Long… >>> More
DNS Tools - DNS and Few of its Concerning Terms and Tools

as seen on Article City - Search for 'Article City'
A DNS or Domain Name System lets you locate computers on a network or the Internet TCP/IP network by domain name. The DNS server sustains a database of domain names or host names along with their cor... [Author: Daisy Osbaldo - Computers and Internet - April 02, 2010] >>> More
Search Engines Online Business Tools For Website Marketing - 3 Free Tools to Optimise Your Website

as seen on Ezine Articles - Search for 'Ezine Articles'
Search engines online business tools for website marketing are available by the thousands, if not millions. Lots of software companies have designed a whole range of different applications to help you optimise your website and marketing campaigns. When I first started with online marketing, I looked… >>> More