Forum Discussion
loading only the needed tables from SQL Server
Hi all, Is there any way to make restrictions, so that I will be able to load ONLY the tables that is required, from the data source.
Yeah, records. When I import dataset from SQL Server, the navigator shows only 10000 records. But i have more than that.
Once you physically import them, it'll be more than that figure. Try it.
Preview does literally what it says... give you a preview.
In SQL terms it just does:
Select top 100000 (*) from YourTable
Importing it does:
Select * from YourTable
EDIT: If you're LITERALLY talking about having 100000 tables (and not records) then just import with a SQL statement instead of using the navigator.