I have a project that requires to send dataset that meet certain criteria
stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
Server 2000 at TX and then update parent's dataset that has been sent before
monthly for whatever changes that have been made over the time. Can somebody
teach me a way how to do it? As I don't know which record what data value has
been changed at our office over the time so as to update the dataset at TX's
SQL Server. It definitely will have changes. Also our SQL Server has limited
resource and the transmitted dataset will be about 400-500K records at the
first population.
Thank you in advance for your help.
Take a look at DTS if you want to try to automate the process.
If you would like to do it by hand, I would suggest that you use bcp to move
the data out to a flat file, WinZip the file and ship it. On the TX
system, bcp that new data into a staging table and then perform your
updates.
Note: Before performing your updates, you should probably back up the TX
database. That way if you really do something strange, you can quickly undo
it.
Rick Sawtell
MCT, MCSD, MCDBA
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> I have a project that requires to send dataset that meet certain criteria
> stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> Server 2000 at TX and then update parent's dataset that has been sent
before
> monthly for whatever changes that have been made over the time. Can
somebody
> teach me a way how to do it? As I don't know which record what data value
has
> been changed at our office over the time so as to update the dataset at
TX's
> SQL Server. It definitely will have changes. Also our SQL Server has
limited
> resource and the transmitted dataset will be about 400-500K records at the
> first population.
> Thank you in advance for your help.
|||Thanks for your help. But how can I tell which record has changes and
requires to do an update to the TX's database?
B.Regards,
Emily
"Rick Sawtell" wrote:
> Take a look at DTS if you want to try to automate the process.
> If you would like to do it by hand, I would suggest that you use bcp to move
> the data out to a flat file, WinZip the file and ship it. On the TX
> system, bcp that new data into a staging table and then perform your
> updates.
> Note: Before performing your updates, you should probably back up the TX
> database. That way if you really do something strange, you can quickly undo
> it.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> before
> somebody
> has
> TX's
> limited
>
>
|||Without looking at your table structures and how the data is handled, I
couldn't tell you.
How would you do it normally?
You could use a RowVersion datatype in the tables at both sites and then
compare them. For RowVersions that are different, you could perform your
updates on those rows.
HTH
Rick Sawtell
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...[vbcol=seagreen]
> Thanks for your help. But how can I tell which record has changes and
> requires to do an update to the TX's database?
> B.Regards,
> Emily
> "Rick Sawtell" wrote:
move[vbcol=seagreen]
TX[vbcol=seagreen]
undo[vbcol=seagreen]
criteria[vbcol=seagreen]
SQL[vbcol=seagreen]
value[vbcol=seagreen]
at[vbcol=seagreen]
the[vbcol=seagreen]
|||The recordset is pulled from different tables by joining the foreign keys
with the main table. None of them has a column with timestamp datatype( I
guess this is the datatype that you refer to as there is no RowVersion
datatype in SQL Server 7.0) .
Correct me if I'm wrong.
All tables that are used to get the recordset have a primary key in integer
datatype like an autonumber but not include in the recordset.
Does it mean we should add an additional column to trigger if there is any
change?
Thank you very much for your help.
Emily
"Rick Sawtell" wrote:
> Without looking at your table structures and how the data is handled, I
> couldn't tell you.
> How would you do it normally?
> You could use a RowVersion datatype in the tables at both sites and then
> compare them. For RowVersions that are different, you could perform your
> updates on those rows.
> HTH
> Rick Sawtell
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> move
> TX
> undo
> criteria
> SQL
> value
> at
> the
>
>
Showing posts with label office. Show all posts
Showing posts with label office. Show all posts
Wednesday, March 28, 2012
How to transfer data to another site and update data later on
I have a project that requires to send dataset that meet certain criteria
stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
Server 2000 at TX and then update parent's dataset that has been sent before
monthly for whatever changes that have been made over the time. Can somebody
teach me a way how to do it? As I don't know which record what data value has
been changed at our office over the time so as to update the dataset at TX's
SQL Server. It definitely will have changes. Also our SQL Server has limited
resource and the transmitted dataset will be about 400-500K records at the
first population.
Thank you in advance for your help.Take a look at DTS if you want to try to automate the process.
If you would like to do it by hand, I would suggest that you use bcp to move
the data out to a flat file, WinZip the file and ship it. On the TX
system, bcp that new data into a staging table and then perform your
updates.
Note: Before performing your updates, you should probably back up the TX
database. That way if you really do something strange, you can quickly undo
it.
Rick Sawtell
MCT, MCSD, MCDBA
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> I have a project that requires to send dataset that meet certain criteria
> stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> Server 2000 at TX and then update parent's dataset that has been sent
before
> monthly for whatever changes that have been made over the time. Can
somebody
> teach me a way how to do it? As I don't know which record what data value
has
> been changed at our office over the time so as to update the dataset at
TX's
> SQL Server. It definitely will have changes. Also our SQL Server has
limited
> resource and the transmitted dataset will be about 400-500K records at the
> first population.
> Thank you in advance for your help.|||Thanks for your help. But how can I tell which record has changes and
requires to do an update to the TX's database?
B.Regards,
Emily
"Rick Sawtell" wrote:
> Take a look at DTS if you want to try to automate the process.
> If you would like to do it by hand, I would suggest that you use bcp to move
> the data out to a flat file, WinZip the file and ship it. On the TX
> system, bcp that new data into a staging table and then perform your
> updates.
> Note: Before performing your updates, you should probably back up the TX
> database. That way if you really do something strange, you can quickly undo
> it.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > I have a project that requires to send dataset that meet certain criteria
> > stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> > Server 2000 at TX and then update parent's dataset that has been sent
> before
> > monthly for whatever changes that have been made over the time. Can
> somebody
> > teach me a way how to do it? As I don't know which record what data value
> has
> > been changed at our office over the time so as to update the dataset at
> TX's
> > SQL Server. It definitely will have changes. Also our SQL Server has
> limited
> > resource and the transmitted dataset will be about 400-500K records at the
> > first population.
> >
> > Thank you in advance for your help.
>
>|||Without looking at your table structures and how the data is handled, I
couldn't tell you.
How would you do it normally?
You could use a RowVersion datatype in the tables at both sites and then
compare them. For RowVersions that are different, you could perform your
updates on those rows.
HTH
Rick Sawtell
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> Thanks for your help. But how can I tell which record has changes and
> requires to do an update to the TX's database?
> B.Regards,
> Emily
> "Rick Sawtell" wrote:
> > Take a look at DTS if you want to try to automate the process.
> >
> > If you would like to do it by hand, I would suggest that you use bcp to
move
> > the data out to a flat file, WinZip the file and ship it. On the TX
> > system, bcp that new data into a staging table and then perform your
> > updates.
> >
> > Note: Before performing your updates, you should probably back up the
TX
> > database. That way if you really do something strange, you can quickly
undo
> > it.
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> > "Emily" <Emily@.discussions.microsoft.com> wrote in message
> > news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > > I have a project that requires to send dataset that meet certain
criteria
> > > stored in SQL Server 7.0 in my office at L.A. to the parent company's
SQL
> > > Server 2000 at TX and then update parent's dataset that has been sent
> > before
> > > monthly for whatever changes that have been made over the time. Can
> > somebody
> > > teach me a way how to do it? As I don't know which record what data
value
> > has
> > > been changed at our office over the time so as to update the dataset
at
> > TX's
> > > SQL Server. It definitely will have changes. Also our SQL Server has
> > limited
> > > resource and the transmitted dataset will be about 400-500K records at
the
> > > first population.
> > >
> > > Thank you in advance for your help.
> >
> >
> >|||The recordset is pulled from different tables by joining the foreign keys
with the main table. None of them has a column with timestamp datatype( I
guess this is the datatype that you refer to as there is no RowVersion
datatype in SQL Server 7.0) .
Correct me if I'm wrong.
All tables that are used to get the recordset have a primary key in integer
datatype like an autonumber but not include in the recordset.
Does it mean we should add an additional column to trigger if there is any
change?
Thank you very much for your help.
Emily
"Rick Sawtell" wrote:
> Without looking at your table structures and how the data is handled, I
> couldn't tell you.
> How would you do it normally?
> You could use a RowVersion datatype in the tables at both sites and then
> compare them. For RowVersions that are different, you could perform your
> updates on those rows.
> HTH
> Rick Sawtell
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> > Thanks for your help. But how can I tell which record has changes and
> > requires to do an update to the TX's database?
> >
> > B.Regards,
> > Emily
> >
> > "Rick Sawtell" wrote:
> >
> > > Take a look at DTS if you want to try to automate the process.
> > >
> > > If you would like to do it by hand, I would suggest that you use bcp to
> move
> > > the data out to a flat file, WinZip the file and ship it. On the TX
> > > system, bcp that new data into a staging table and then perform your
> > > updates.
> > >
> > > Note: Before performing your updates, you should probably back up the
> TX
> > > database. That way if you really do something strange, you can quickly
> undo
> > > it.
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > > "Emily" <Emily@.discussions.microsoft.com> wrote in message
> > > news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > > > I have a project that requires to send dataset that meet certain
> criteria
> > > > stored in SQL Server 7.0 in my office at L.A. to the parent company's
> SQL
> > > > Server 2000 at TX and then update parent's dataset that has been sent
> > > before
> > > > monthly for whatever changes that have been made over the time. Can
> > > somebody
> > > > teach me a way how to do it? As I don't know which record what data
> value
> > > has
> > > > been changed at our office over the time so as to update the dataset
> at
> > > TX's
> > > > SQL Server. It definitely will have changes. Also our SQL Server has
> > > limited
> > > > resource and the transmitted dataset will be about 400-500K records at
> the
> > > > first population.
> > > >
> > > > Thank you in advance for your help.
> > >
> > >
> > >
>
>
stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
Server 2000 at TX and then update parent's dataset that has been sent before
monthly for whatever changes that have been made over the time. Can somebody
teach me a way how to do it? As I don't know which record what data value has
been changed at our office over the time so as to update the dataset at TX's
SQL Server. It definitely will have changes. Also our SQL Server has limited
resource and the transmitted dataset will be about 400-500K records at the
first population.
Thank you in advance for your help.Take a look at DTS if you want to try to automate the process.
If you would like to do it by hand, I would suggest that you use bcp to move
the data out to a flat file, WinZip the file and ship it. On the TX
system, bcp that new data into a staging table and then perform your
updates.
Note: Before performing your updates, you should probably back up the TX
database. That way if you really do something strange, you can quickly undo
it.
Rick Sawtell
MCT, MCSD, MCDBA
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> I have a project that requires to send dataset that meet certain criteria
> stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> Server 2000 at TX and then update parent's dataset that has been sent
before
> monthly for whatever changes that have been made over the time. Can
somebody
> teach me a way how to do it? As I don't know which record what data value
has
> been changed at our office over the time so as to update the dataset at
TX's
> SQL Server. It definitely will have changes. Also our SQL Server has
limited
> resource and the transmitted dataset will be about 400-500K records at the
> first population.
> Thank you in advance for your help.|||Thanks for your help. But how can I tell which record has changes and
requires to do an update to the TX's database?
B.Regards,
Emily
"Rick Sawtell" wrote:
> Take a look at DTS if you want to try to automate the process.
> If you would like to do it by hand, I would suggest that you use bcp to move
> the data out to a flat file, WinZip the file and ship it. On the TX
> system, bcp that new data into a staging table and then perform your
> updates.
> Note: Before performing your updates, you should probably back up the TX
> database. That way if you really do something strange, you can quickly undo
> it.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > I have a project that requires to send dataset that meet certain criteria
> > stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> > Server 2000 at TX and then update parent's dataset that has been sent
> before
> > monthly for whatever changes that have been made over the time. Can
> somebody
> > teach me a way how to do it? As I don't know which record what data value
> has
> > been changed at our office over the time so as to update the dataset at
> TX's
> > SQL Server. It definitely will have changes. Also our SQL Server has
> limited
> > resource and the transmitted dataset will be about 400-500K records at the
> > first population.
> >
> > Thank you in advance for your help.
>
>|||Without looking at your table structures and how the data is handled, I
couldn't tell you.
How would you do it normally?
You could use a RowVersion datatype in the tables at both sites and then
compare them. For RowVersions that are different, you could perform your
updates on those rows.
HTH
Rick Sawtell
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> Thanks for your help. But how can I tell which record has changes and
> requires to do an update to the TX's database?
> B.Regards,
> Emily
> "Rick Sawtell" wrote:
> > Take a look at DTS if you want to try to automate the process.
> >
> > If you would like to do it by hand, I would suggest that you use bcp to
move
> > the data out to a flat file, WinZip the file and ship it. On the TX
> > system, bcp that new data into a staging table and then perform your
> > updates.
> >
> > Note: Before performing your updates, you should probably back up the
TX
> > database. That way if you really do something strange, you can quickly
undo
> > it.
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> > "Emily" <Emily@.discussions.microsoft.com> wrote in message
> > news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > > I have a project that requires to send dataset that meet certain
criteria
> > > stored in SQL Server 7.0 in my office at L.A. to the parent company's
SQL
> > > Server 2000 at TX and then update parent's dataset that has been sent
> > before
> > > monthly for whatever changes that have been made over the time. Can
> > somebody
> > > teach me a way how to do it? As I don't know which record what data
value
> > has
> > > been changed at our office over the time so as to update the dataset
at
> > TX's
> > > SQL Server. It definitely will have changes. Also our SQL Server has
> > limited
> > > resource and the transmitted dataset will be about 400-500K records at
the
> > > first population.
> > >
> > > Thank you in advance for your help.
> >
> >
> >|||The recordset is pulled from different tables by joining the foreign keys
with the main table. None of them has a column with timestamp datatype( I
guess this is the datatype that you refer to as there is no RowVersion
datatype in SQL Server 7.0) .
Correct me if I'm wrong.
All tables that are used to get the recordset have a primary key in integer
datatype like an autonumber but not include in the recordset.
Does it mean we should add an additional column to trigger if there is any
change?
Thank you very much for your help.
Emily
"Rick Sawtell" wrote:
> Without looking at your table structures and how the data is handled, I
> couldn't tell you.
> How would you do it normally?
> You could use a RowVersion datatype in the tables at both sites and then
> compare them. For RowVersions that are different, you could perform your
> updates on those rows.
> HTH
> Rick Sawtell
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> > Thanks for your help. But how can I tell which record has changes and
> > requires to do an update to the TX's database?
> >
> > B.Regards,
> > Emily
> >
> > "Rick Sawtell" wrote:
> >
> > > Take a look at DTS if you want to try to automate the process.
> > >
> > > If you would like to do it by hand, I would suggest that you use bcp to
> move
> > > the data out to a flat file, WinZip the file and ship it. On the TX
> > > system, bcp that new data into a staging table and then perform your
> > > updates.
> > >
> > > Note: Before performing your updates, you should probably back up the
> TX
> > > database. That way if you really do something strange, you can quickly
> undo
> > > it.
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > > "Emily" <Emily@.discussions.microsoft.com> wrote in message
> > > news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> > > > I have a project that requires to send dataset that meet certain
> criteria
> > > > stored in SQL Server 7.0 in my office at L.A. to the parent company's
> SQL
> > > > Server 2000 at TX and then update parent's dataset that has been sent
> > > before
> > > > monthly for whatever changes that have been made over the time. Can
> > > somebody
> > > > teach me a way how to do it? As I don't know which record what data
> value
> > > has
> > > > been changed at our office over the time so as to update the dataset
> at
> > > TX's
> > > > SQL Server. It definitely will have changes. Also our SQL Server has
> > > limited
> > > > resource and the transmitted dataset will be about 400-500K records at
> the
> > > > first population.
> > > >
> > > > Thank you in advance for your help.
> > >
> > >
> > >
>
>
How to transfer data to another site and update data later on
I have a project that requires to send dataset that meet certain criteria
stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
Server 2000 at TX and then update parent's dataset that has been sent before
monthly for whatever changes that have been made over the time. Can somebody
teach me a way how to do it? As I don't know which record what data value ha
s
been changed at our office over the time so as to update the dataset at TX's
SQL Server. It definitely will have changes. Also our SQL Server has limited
resource and the transmitted dataset will be about 400-500K records at the
first population.
Thank you in advance for your help.Take a look at DTS if you want to try to automate the process.
If you would like to do it by hand, I would suggest that you use bcp to move
the data out to a flat file, WinZip the file and ship it. On the TX
system, bcp that new data into a staging table and then perform your
updates.
Note: Before performing your updates, you should probably back up the TX
database. That way if you really do something strange, you can quickly undo
it.
Rick Sawtell
MCT, MCSD, MCDBA
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> I have a project that requires to send dataset that meet certain criteria
> stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> Server 2000 at TX and then update parent's dataset that has been sent
before
> monthly for whatever changes that have been made over the time. Can
somebody
> teach me a way how to do it? As I don't know which record what data value
has
> been changed at our office over the time so as to update the dataset at
TX's
> SQL Server. It definitely will have changes. Also our SQL Server has
limited
> resource and the transmitted dataset will be about 400-500K records at the
> first population.
> Thank you in advance for your help.|||Thanks for your help. But how can I tell which record has changes and
requires to do an update to the TX's database?
B.Regards,
Emily
"Rick Sawtell" wrote:
> Take a look at DTS if you want to try to automate the process.
> If you would like to do it by hand, I would suggest that you use bcp to mo
ve
> the data out to a flat file, WinZip the file and ship it. On the TX
> system, bcp that new data into a staging table and then perform your
> updates.
> Note: Before performing your updates, you should probably back up the TX
> database. That way if you really do something strange, you can quickly un
do
> it.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> before
> somebody
> has
> TX's
> limited
>
>|||Without looking at your table structures and how the data is handled, I
couldn't tell you.
How would you do it normally?
You could use a RowVersion datatype in the tables at both sites and then
compare them. For RowVersions that are different, you could perform your
updates on those rows.
HTH
Rick Sawtell
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...[vbcol=seagreen]
> Thanks for your help. But how can I tell which record has changes and
> requires to do an update to the TX's database?
> B.Regards,
> Emily
> "Rick Sawtell" wrote:
>
move[vbcol=seagreen]
TX[vbcol=seagreen]
undo[vbcol=seagreen]
criteria[vbcol=seagreen]
SQL[vbcol=seagreen]
value[vbcol=seagreen]
at[vbcol=seagreen]
the[vbcol=seagreen]|||The recordset is pulled from different tables by joining the foreign keys
with the main table. None of them has a column with timestamp datatype( I
guess this is the datatype that you refer to as there is no RowVersion
datatype in SQL Server 7.0) .
Correct me if I'm wrong.
All tables that are used to get the recordset have a primary key in integer
datatype like an autonumber but not include in the recordset.
Does it mean we should add an additional column to trigger if there is any
change?
Thank you very much for your help.
Emily
"Rick Sawtell" wrote:
> Without looking at your table structures and how the data is handled, I
> couldn't tell you.
> How would you do it normally?
> You could use a RowVersion datatype in the tables at both sites and then
> compare them. For RowVersions that are different, you could perform your
> updates on those rows.
> HTH
> Rick Sawtell
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> move
> TX
> undo
> criteria
> SQL
> value
> at
> the
>
>
stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
Server 2000 at TX and then update parent's dataset that has been sent before
monthly for whatever changes that have been made over the time. Can somebody
teach me a way how to do it? As I don't know which record what data value ha
s
been changed at our office over the time so as to update the dataset at TX's
SQL Server. It definitely will have changes. Also our SQL Server has limited
resource and the transmitted dataset will be about 400-500K records at the
first population.
Thank you in advance for your help.Take a look at DTS if you want to try to automate the process.
If you would like to do it by hand, I would suggest that you use bcp to move
the data out to a flat file, WinZip the file and ship it. On the TX
system, bcp that new data into a staging table and then perform your
updates.
Note: Before performing your updates, you should probably back up the TX
database. That way if you really do something strange, you can quickly undo
it.
Rick Sawtell
MCT, MCSD, MCDBA
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> I have a project that requires to send dataset that meet certain criteria
> stored in SQL Server 7.0 in my office at L.A. to the parent company's SQL
> Server 2000 at TX and then update parent's dataset that has been sent
before
> monthly for whatever changes that have been made over the time. Can
somebody
> teach me a way how to do it? As I don't know which record what data value
has
> been changed at our office over the time so as to update the dataset at
TX's
> SQL Server. It definitely will have changes. Also our SQL Server has
limited
> resource and the transmitted dataset will be about 400-500K records at the
> first population.
> Thank you in advance for your help.|||Thanks for your help. But how can I tell which record has changes and
requires to do an update to the TX's database?
B.Regards,
Emily
"Rick Sawtell" wrote:
> Take a look at DTS if you want to try to automate the process.
> If you would like to do it by hand, I would suggest that you use bcp to mo
ve
> the data out to a flat file, WinZip the file and ship it. On the TX
> system, bcp that new data into a staging table and then perform your
> updates.
> Note: Before performing your updates, you should probably back up the TX
> database. That way if you really do something strange, you can quickly un
do
> it.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:6CDB8949-4450-4F4E-9A07-F67950847298@.microsoft.com...
> before
> somebody
> has
> TX's
> limited
>
>|||Without looking at your table structures and how the data is handled, I
couldn't tell you.
How would you do it normally?
You could use a RowVersion datatype in the tables at both sites and then
compare them. For RowVersions that are different, you could perform your
updates on those rows.
HTH
Rick Sawtell
"Emily" <Emily@.discussions.microsoft.com> wrote in message
news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...[vbcol=seagreen]
> Thanks for your help. But how can I tell which record has changes and
> requires to do an update to the TX's database?
> B.Regards,
> Emily
> "Rick Sawtell" wrote:
>
move[vbcol=seagreen]
TX[vbcol=seagreen]
undo[vbcol=seagreen]
criteria[vbcol=seagreen]
SQL[vbcol=seagreen]
value[vbcol=seagreen]
at[vbcol=seagreen]
the[vbcol=seagreen]|||The recordset is pulled from different tables by joining the foreign keys
with the main table. None of them has a column with timestamp datatype( I
guess this is the datatype that you refer to as there is no RowVersion
datatype in SQL Server 7.0) .
Correct me if I'm wrong.
All tables that are used to get the recordset have a primary key in integer
datatype like an autonumber but not include in the recordset.
Does it mean we should add an additional column to trigger if there is any
change?
Thank you very much for your help.
Emily
"Rick Sawtell" wrote:
> Without looking at your table structures and how the data is handled, I
> couldn't tell you.
> How would you do it normally?
> You could use a RowVersion datatype in the tables at both sites and then
> compare them. For RowVersions that are different, you could perform your
> updates on those rows.
> HTH
> Rick Sawtell
>
> "Emily" <Emily@.discussions.microsoft.com> wrote in message
> news:B40AE998-4ABF-4DC8-8954-4F0E938018C3@.microsoft.com...
> move
> TX
> undo
> criteria
> SQL
> value
> at
> the
>
>
How to transfer data from one sql server to another sql server 7.0
Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a bran
ch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via acces
s
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
>
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You[vbcol=seagreen]
> using
> branch
> data
> built
> have
> access
>
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a bran
ch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via acces
s
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
>
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You[vbcol=seagreen]
> using
> branch
> data
> built
> have
> access
>
How to transfer data from one sql server to another sql server 7.0
Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.com
Hi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]
|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data[vbcol=seagreen]
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You
> using
> branch
> data
> built
> have
> access
>
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.com
Hi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]
|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data[vbcol=seagreen]
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You
> using
> branch
> data
> built
> have
> access
>
How to transfer data from one sql server to another sql server 7.0
Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
> > Dear All
> > i have small data to transfer, let me explain it,
> > I have to transfer some small data from head office (sql server) to a
branch
> > office (sql server)
> > the main objective is that the task should be automated via front end
> > developed in VB 6.0
> > The user at head office just choose option from front end to transfer
data
> > and the user at branch office just select option to receive data, the
> > remainin task should be performed at the back end.
> >
> > I just want to know the best technique to transfer the data, i have
built
> > same type of solution using foxpro by sending data in text file. as i
have
> > some ideas in my mind that data can be transfered via text file, via
access
> > mdb file etc. etc., but what is the best technique.
> > please help if u can
> > Regards
> > Abdul Hameed
> > hsbilal@.gmail.com
> >
> >
> >
> >|||See inline
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> > Hi Abdul,
> >
> > I feel the best option for you will be using Data Transformation
Servics.
> > DTS not only helps to transfer data, it also helps to transform data.
You
> > will be able to invoke the DTS package from your Visual Basic Program
> using
> > the COM interface provided by DTS.
> >
> > Thanks & Regards
> > Shri.DBA
> >
> > "Abdul Hameed" wrote:
> >
> > > Dear All
> > > i have small data to transfer, let me explain it,
> > > I have to transfer some small data from head office (sql server) to a
> branch
> > > office (sql server)
> > > the main objective is that the task should be automated via front end
> > > developed in VB 6.0
> > > The user at head office just choose option from front end to transfer
> data
> > > and the user at branch office just select option to receive data, the
> > > remainin task should be performed at the back end.
> > >
> > > I just want to know the best technique to transfer the data, i have
> built
> > > same type of solution using foxpro by sending data in text file. as i
> have
> > > some ideas in my mind that data can be transfered via text file, via
> access
> > > mdb file etc. etc., but what is the best technique.
> > > please help if u can
> > > Regards
> > > Abdul Hameed
> > > hsbilal@.gmail.com
> > >
> > >
> > >
> > >
>
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
> > Dear All
> > i have small data to transfer, let me explain it,
> > I have to transfer some small data from head office (sql server) to a
branch
> > office (sql server)
> > the main objective is that the task should be automated via front end
> > developed in VB 6.0
> > The user at head office just choose option from front end to transfer
data
> > and the user at branch office just select option to receive data, the
> > remainin task should be performed at the back end.
> >
> > I just want to know the best technique to transfer the data, i have
built
> > same type of solution using foxpro by sending data in text file. as i
have
> > some ideas in my mind that data can be transfered via text file, via
access
> > mdb file etc. etc., but what is the best technique.
> > please help if u can
> > Regards
> > Abdul Hameed
> > hsbilal@.gmail.com
> >
> >
> >
> >|||See inline
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> > Hi Abdul,
> >
> > I feel the best option for you will be using Data Transformation
Servics.
> > DTS not only helps to transfer data, it also helps to transform data.
You
> > will be able to invoke the DTS package from your Visual Basic Program
> using
> > the COM interface provided by DTS.
> >
> > Thanks & Regards
> > Shri.DBA
> >
> > "Abdul Hameed" wrote:
> >
> > > Dear All
> > > i have small data to transfer, let me explain it,
> > > I have to transfer some small data from head office (sql server) to a
> branch
> > > office (sql server)
> > > the main objective is that the task should be automated via front end
> > > developed in VB 6.0
> > > The user at head office just choose option from front end to transfer
> data
> > > and the user at branch office just select option to receive data, the
> > > remainin task should be performed at the back end.
> > >
> > > I just want to know the best technique to transfer the data, i have
> built
> > > same type of solution using foxpro by sending data in text file. as i
> have
> > > some ideas in my mind that data can be transfered via text file, via
> access
> > > mdb file etc. etc., but what is the best technique.
> > > please help if u can
> > > Regards
> > > Abdul Hameed
> > > hsbilal@.gmail.com
> > >
> > >
> > >
> > >
>
Subscribe to:
Posts (Atom)