![]() I can certainly alter the scripts that I output from SQL Server to modify the resulting output to insert 1000 records at a time but it's much easier to use a tool that simply allows me to specify how many records I want to include in each insert statement. If you want something more graphical try pentaho spoon. Since this is part of an installation process, while performance is a factor, it isn't highly critical the more important factor is in keeping the installation process as simple as possible with as few steps as possible. RazorSQL is a SQL query tool, database browser, SQL editor and database management. you can read any CSV of any complexity and connect to any database. There are various ways to export data to CSV, but export to SQL is almost always. In your filesystem, theres a file called cereal.csv that contains nutrition data on 80 cereals. By inserting 1000 records at a time I bring the process of populating these tables from several minutes down to a few seconds. The quick and expensive way is to use RazorSQL, which costs 70. The default data often changes between release levels so I typically script the data out of our QA database as insert statements for inclusion in the installation scripts. We have a few tables with thousands of records and one table in particular that has around 9000 rows. We have sql scripts to create and populate these tables that must be executed during the installation process. ![]() ![]() The product we sell has a set of tables that needs to be initialized with default data.
0 Comments
Leave a Reply. |