Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2004-10-05 : 19:08:42
|
| Hi,What tools are available to create DML ? Tara had recommended a product by RedGate awhile ago to me but I'm wondering if theres anything free out there? I don't need anything too advanced and can't afford to pay for it.Basically I have few databases and want to move the data in the tables across to eachother from time to time for testing purposes.Thanks a bunch,Mike123 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-05 : 19:10:43
|
| To move data between databases, use bcp.exe, DTS, or INSERT INTO SELECT * FROM.To create DML statements:http://vyaskn.tripod.com/code.htm#insertsTara |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-05 : 19:34:27
|
| sweet.. ill try to play around with bcp and dts and see how that goes...... if not I'll try the DML SPthanks again Tara :)Mike123 |
|
|
|
|
|
|
Creating DML