Rene S
|
| Posted: 02/24/2006, 3:19 AM |
|
Hi,
I'm not a computer specialist (not a specialist period) but how would I go about using our company's sql server database and then "upload" part of that database to our provider?
What I mean is: our database holds 10.000.000+ records with production, customers, products etc. I only want to use certain records/tables. Is it possible to run 1 or several query's and then use that data to upload to provider?
How would you do something like that? Could you advice me or point me to a nice and clear example? (I'm simple, keep that in mind)
Thanks,
Rene
|
|
|
 |
wkempees
|
| Posted: 02/24/2006, 4:10 AM |
|
Rene,
Not being a specialist, I would advice you to hire one.
Tools you are looking for are standard SQL query tools, that would enable
you to extract rows from tables (1) transfer (2) or even synchronize (3)
Barriers you are facing could be different SQL Database engines, setting,
versions.
Migration tools, Extraction tools are what you are looking for.
Sit down a draw the map on you comp's database, decide what you need to have
at the Hosts.
Deduct the needed SQL and keep into account what will be needed after inital
upload, is data to be kept sync'ed?
Walter
<ReneS@forum.codecharge (Rene S)> schreef in bericht
news:243feebdc8e561@news.codecharge.com...
> Hi,
>
> I'm not a computer specialist (not a specialist period) but how would I go
> about using our company's sql server database and then "upload" part of
> that
> database to our provider?
>
> What I mean is: our database holds 10.000.000+ records with production,
> customers, products etc. I only want to use certain records/tables. Is it
> possible to run 1 or several query's and then use that data to upload to
> provider?
>
> How would you do something like that? Could you advice me or point me to a
> nice
> and clear example? (I'm simple, keep that in mind)
>
> Thanks,
>
> Rene
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Rene S
|
| Posted: 02/24/2006, 8:05 AM |
|
Thanks Walter,
It would have been a nice challenge to do it myself but your answer made it clear that that will not be an option.
Maybe an option is to extract the records I need to access (once a week) and upload that?
I'll hire a specialist......
Rene
|
|
|
|
wkempees
|
| Posted: 02/24/2006, 12:57 PM |
|
Rene,
This will probably be a barrier, but I can (at very reasonable......) do it
for you.
The barrier being will your company be willing to let a third party in on
their data secrets.
We can write you the working scripts to do the extraction and update/replace
the data at you isp server.
It will be done in the "we do it for you, but also show you how and how to"
Can also pint you the tools to use.
But, as this is not a commercial forum, a lot of others can too.
Walter
<ReneS@forum.codecharge (Rene S)> schreef in bericht
news:243feebdc8e561@news.codecharge.com...
> Hi,
>
> I'm not a computer specialist (not a specialist period) but how would I go
> about using our company's sql server database and then "upload" part of
> that
> database to our provider?
>
> What I mean is: our database holds 10.000.000+ records with production,
> customers, products etc. I only want to use certain records/tables. Is it
> possible to run 1 or several query's and then use that data to upload to
> provider?
>
> How would you do something like that? Could you advice me or point me to a
> nice
> and clear example? (I'm simple, keep that in mind)
>
> Thanks,
>
> Rene
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Rene S
|
| Posted: 02/24/2006, 1:36 PM |
|
Walter,
Right now we are at the stage of putting things together. It means that for our company we are getting a new tracking and tracing (barcodes etc.) system, a new payroll, hrm, crm etc. system. Once that is to our satisfaction, then a website with "automated update" will be neccesary. Should be ready june/july, maybe then I'll contact you.. (you are in high esteem (did i spell that correctly?)) (oftewel hoog gewaardeerd)
First see if the programmers can finish it all....(these programmers lack time (everytime))
Thanks,
Rene
|
|
|
|
wkempees
|
| Posted: 02/24/2006, 1:51 PM |
|
Rene,
Thanks for the "high esteem".
Probably, I think, we are closer together then we might all think.
Thinking out of the box: we are both the same distance from Las Vegas.
Bedankt voor compliment.
walter punt kempees apestaartje consultair punt nl
<ReneS@forum.codecharge (Rene S)> schreef in bericht
news:243feebdc8e561@news.codecharge.com...
> Hi,
>
> I'm not a computer specialist (not a specialist period) but how would I go
> about using our company's sql server database and then "upload" part of
> that
> database to our provider?
>
> What I mean is: our database holds 10.000.000+ records with production,
> customers, products etc. I only want to use certain records/tables. Is it
> possible to run 1 or several query's and then use that data to upload to
> provider?
>
> How would you do something like that? Could you advice me or point me to a
> nice
> and clear example? (I'm simple, keep that in mind)
>
> Thanks,
>
> Rene
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
