SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2004
    Location
    london
    Posts
    145
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exporting MS SQL data into upgraded MS SQL database

    I have a bit of a situation and I am new with this sort of operation. I have an MS SQL database that runs an application. This application was recently upgraded but I need to transfer the data over to the new database somehow.

    Now I am using the import/export wizard for Studio Express but I have a couple of questions...

    The database structure probably has changed a bit on the new MS SQL database. When I go to import, will it put the data into the correct fields? Even if there are new fields perhaps?

    Is there anything I should be concerned with and watch for?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by dutton View Post
    The database structure probably has changed a bit on the new MS SQL database. When I go to import, will it put the data into the correct fields? Even if there are new fields perhaps?
    i'll give it a qualified yes

    if you have touched none of the existing columns, just added new ones, then the load should work (provided you do something to ensure proper values are entered into the new columns too)

    if some of the old columns are missing or have datatypes changed, all bets are off and you may have to write the matching SQL by hand
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,653
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Is this a vendor-built application or a custom application? Are there any upgrade scripts lying around?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •