I'm tasked to import a database from PROGRESS to SQL Server. I'm about to establish a "Linked Server" using PROGRESS' ODBC driver.
I need to go grab all tables and all their contents - some quite large. Overall, the current PROGRESS database stands at about 135 GB of disk space needed.
Any idea / guesstimate how much the SQL Server database will be??
Also: what's the optimal recovery model for this bulk operation -
simple?? Any guess how much log file space I will be needing? I don't have any row counts for the PROGRESS database tables just yet, unfortunately - but the data is mostly text and numbers - no blobs or anything of that nature