Posts tagged database

Auto Generate Insert Statements from your Data

0
2 years ago
by admin in , ,

Hi guys,

I am was browsing around and found this stored procedures by Vyas Kondreddi.
The stored procedure is stored in your master database, and you will be able to use it for any database to generate yr inserts statement.

The result is good and confirm save a lot time for data migration.

SQL 2005 Express, where is the DTS wizards?

0
3 years ago
by aliank in , ,

Hmm, was looking up and down for the DTS wizards in the SQL Express Management Studios to transfer data to another test database. Hold and behold, there is actually DTS Wizards hidden in the SQL Express installation folder. Found it here: C:\Program Files\Microsoft SQL Server\90\DTS\Binn. Works like wonders.

Go to Top