Move Data between old app and new version?

[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

 

[Graham R Seach]

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

 

[Jerry Whittle]

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.

 

[_Stephen]

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

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

 

[Graham R Seach]

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
---------------------------

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

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

 

[_Stephen]

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

Thanks for the heads up on the order of move.

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

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