Migrating data from one SQL Server database to another can be challenging. Steve Jones has a new series that looks at various techniques that he's used to move data into a new database. This one looks at how you can quickly take Excel based data and insert it into a new database without using DTS.
2004-07-08
10,539 reads
2004-05-05
1,762 reads
Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.
2005-09-23 (first published: 2004-05-03)
40,322 reads
2004-04-23
1,779 reads
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
2004-04-08
9,877 reads
This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.
2017-08-23 (first published: 2004-03-24)
56,854 reads
2004-03-10
1,654 reads
2004-03-08
2,313 reads
2004-03-08
10,994 reads
2004-01-23
1,096 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers