Re: how to insert xml into sql 2005
- From: "Mike C#" <xyz@xxxxxxx>
- Date: Sun, 20 Jan 2008 18:51:29 -0500
"Dee" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B13371F0-436D-4E36-92B4-792CF1C90FF8@xxxxxxxxxxxxxxxx
Thanks Mike,
Will this work if the access data is set up mostly in querries?
If you set up a linked server on the SQL side or as linked tabels on the
Access side the DBMS (SQL or Access) will see the other's tables as local
tables. So you can query them as if they were local tables. Not sure if
that's the answer you're looking for, because I really don't understand the
question...
There is a performance penalty I forgot to mention previously when you do
this. For instance, on Access if you perform a join to a linked table the
Jet engine pulls the entire table from SQL Server and performs the join
itself locally. For large tables this can be a huge performance hit, but
for small tables it won't matter too much. There are ways to avoid this,
like "pass-through" queries.
I would recommend loading your Access data into tables located on SQL Server
at some point so you can do all queries and data comparisons locally on the
SQL Server. Access has a nice little Upsizing Wizard that can do the basic
upgrade for you, although you'll still have to set up some sort of routine
to update the data on a regular basis. OTOH, you may be in a situation where
you're stuck with Access.
.
- Follow-Ups:
- Re: how to insert xml into sql 2005
- From: Dee
- Re: how to insert xml into sql 2005
- References:
- how to insert xml into sql 2005
- From: Dee
- Re: how to insert xml into sql 2005
- From: Mike C#
- Re: how to insert xml into sql 2005
- From: Dee
- Re: how to insert xml into sql 2005
- From: Mike C#
- Re: how to insert xml into sql 2005
- From: Dee
- how to insert xml into sql 2005
- Prev by Date: Re: how to insert xml into sql 2005
- Next by Date: Re: how to insert xml into sql 2005
- Previous by thread: Re: how to insert xml into sql 2005
- Next by thread: Re: how to insert xml into sql 2005
- Index(es):
Relevant Pages
|
