Good Question,

I do the same here, running development on a virtual server.

But my guess is you should shut down your virtual O.S, cause i have seen locks on VM-Ware...

Hi,

Our production server has 4Gb Physical memory

2 x Quad Core Cpu 2.6Mhz

Main database : approx. 1Gb with low load for the moment (busy migrating old application to sqlserver en...

Parthipan,

You could look into Ms LogParser utility,

I find it an amazing tools and its core exsitence is there to read, analyze and manipulate logfiles

It can also be used to make...

Yep me 2,

Working from Development to Test to Production is done in a second with the Redgate Soft,

+ the Sqldoc included comes in handy also..

SQLPrompt is also fine to have...

Hey Homebrew,

tnx a lot for making it clear for me, 🙂

wkr,

Eddy

Sorry, i guess my question was not totally clear..

Backup in step 3 is been taken by redgates' sqlbackup (every night same time)

The backup/restore in step 2 is a T-Sql script...

Guy (9/15/2008)

---

Ghandi,

From what I tested, SQL does not allow you to document the db down to the fields level. It is a great tool if you do not need to...

The method i just described can also be used for SSIS via odbc

i have tested that...

It depends on what you exactly wish to export/import ..

For us its just as simple as keeping the customers in sync so we chose to put our progress developer at...

HI,

Nope, this does not require progress programming as such..

altough you should have a little basic knowledge about progress 4GL.

Because the way we did it for certain data that has to...

It is indeed just like jgrubb said, verry hard to find a DBA for progress or even a developper,

As progress said to us, we are a fairly big player in...

PS: i would NOT suggest the linked server method

Have tried that for myself but was a little disaster

PS: dont forget that progress is NOT only a database it is also...

Hi,

We work with progress also, and are in the middle of changing our progress application env. to a SQL-Server backend with a windev application on the foreground.

We also have got...

GSquared,

Thats what i have proposed also,

I have set up a night job that will search for all records older then 7 day's and move them to an archive table,

That way...

Tnx for the replys,

Really appreciate hints from people who know what there doing.,

So i can safely create those extra indexes and check each one of them by running a query...