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,554 reads
2004-05-05
1,766 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,355 reads
2004-04-23
1,782 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,911 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.
2005-11-25 (first published: 2004-03-24)
56,992 reads
2004-03-10
1,660 reads
2004-03-08
2,322 reads
2004-03-08
11,034 reads
2004-01-23
1,103 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Hi, Do you know if there is a way to get more detailed logging...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers