May 20, 2003 at 1:30 pm
i have my tables in sql server and would like test data to be entered into all of them...i was wondering is there is an easy way to do this or am i going to have to write a lot of insert statements...i came across something called Bulk Insert which populates tables using data from a text file...is this the way to do it or is there another way?
May 21, 2003 at 8:17 am
Quest-Software has a tool called DataFactory which creates testdata.
http://www.quest.com/datafactory/index.asp
[font="Verdana"]Markus Bohse[/font]
May 21, 2003 at 10:25 am
BCP is one way or if you have sample data in another format, such as Access, Excel, Oracle etc, then you can move data into SQL using DTS.
Clive Strong
May 21, 2003 at 10:39 am
what about using a BULK INSERT after i enter data into a text file...
May 21, 2003 at 11:41 am
Sounds like 'import data' from the Enterpise Manager' interface is your best bet (fast and easy). This is along the same lines as 'cstrong' and it does cover text files.
Everett Wilson
ewilson10@yahoo.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply