Move Data between old app and new version?

  • Thread starter Thread starter SRussell
  • Start date Start date
S

SRussell

What is the best process for taking my updated version of my friends app,
truncate all the tables and bring in ALL of their current data?

Can you write a
delete from ThatTable where 1=1?

then

INSERT INTO [MyTable] (customerID, SOnumber, status)
SELECT (customerID, SOnumber, Status) FROM [theOtherAPP.MyTable]

Or is there a better manner to accomplish this? I am fine using SQL Server
data if that is better to accomplish this.

TIA
 
You can do it that way, or you can import the tables.
Tables | New | Import Table

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Data migration is always a PITA when moving from a new version of an
application. However I bet this one might be easier - the next time.

Access has an "all your eggs in one basket" design where by default
everything is in one mdb file. This causes problems when you are developing
an application off-line while people are still putting in data in production.
The trick is to split the database into a Front End (FE) and Back End (BE).
The BE contains all the tables and data while the FE has the forms, reports,
etc. If you are only messing with the FE, you do not need to migrate data in
the BE. Just put out the new FE mdb file and link it to the BE.

If the above is the case, investigate splitting the database so that you
don't have data migration problems next time. Splitting also cuts down on
database corruption issues and helps speed up things in a multi-user
environment.
 
Graham R Seach said:
You can do it that way, or you can import the tables.
Tables | New | Import Table
Click to expand...

Thanks, this comes across as way to easy :)

Ok, I get messages for breaking relationships to a prior copy I can only
guess. Will my queries be in jeporday if these relationships are not reset?
Or should I just go ahead and be done with it?

Will Autonumbers be screwed?

__Stephen




SRussell said:
What is the best process for taking my updated version of my friends app,
truncate all the tables and bring in ALL of their current data?

Can you write a
delete from ThatTable where 1=1?

then

INSERT INTO [MyTable] (customerID, SOnumber, status)
SELECT (customerID, SOnumber, Status) FROM [theOtherAPP.MyTable]

Or is there a better manner to accomplish this? I am fine using SQL
Server data if that is better to accomplish this.

TIA
Click to expand...
Click to expand...
 
You have to take a look at the existing relationships, because you have to
move the data over in relationship order; parent tables first.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

_Stephen said:
Graham R Seach said:
You can do it that way, or you can import the tables.
Tables | New | Import Table
Click to expand...

Thanks, this comes across as way to easy :)

Ok, I get messages for breaking relationships to a prior copy I can only
guess. Will my queries be in jeporday if these relationships are not
reset? Or should I just go ahead and be done with it?

Will Autonumbers be screwed?

__Stephen




SRussell said:
What is the best process for taking my updated version of my friends
app, truncate all the tables and bring in ALL of their current data?

Can you write a
delete from ThatTable where 1=1?

then

INSERT INTO [MyTable] (customerID, SOnumber, status)
SELECT (customerID, SOnumber, Status) FROM [theOtherAPP.MyTable]

Or is there a better manner to accomplish this? I am fine using SQL
Server data if that is better to accomplish this.

TIA
Click to expand...
Click to expand...
Click to expand...
 
Graham R Seach said:
You have to take a look at the existing relationships, because you have to
move the data over in relationship order; parent tables first.
Click to expand...


Thanks for the heads up on the order of move.

_Stephen said:
Graham R Seach said:
You can do it that way, or you can import the tables.
Tables | New | Import Table
Click to expand...

Thanks, this comes across as way to easy :)

Ok, I get messages for breaking relationships to a prior copy I can only
guess. Will my queries be in jeporday if these relationships are not
reset? Or should I just go ahead and be done with it?

Will Autonumbers be screwed?

__Stephen




What is the best process for taking my updated version of my friends
app, truncate all the tables and bring in ALL of their current data?

Can you write a
delete from ThatTable where 1=1?

then

INSERT INTO [MyTable] (customerID, SOnumber, status)
SELECT (customerID, SOnumber, Status) FROM [theOtherAPP.MyTable]

Or is there a better manner to accomplish this? I am fine using SQL
Server data if that is better to accomplish this.

TIA
Click to expand...
Click to expand...
Click to expand...
 
Back
Top