No Longer Set
  • Home
  • Topics
  • Code Library
  • Tags
  • About
Subscribe
Tagged

Migration

A collection of 6 posts

Scripted SQL Server Migrations
Migration

Scripted SQL Server Migrations

Use this batch file to automatically backup a database on one instance of SQL Server and restore it on a different instance of SQL Server.

  • Mike Wolfe
Mike Wolfe Jun 9, 2022 • 6 min read
SQL Server Migration Steps
Migration

SQL Server Migration Steps

My SQL Server migration philosophy consists of two priorities: (1) Avoid disasters and (2) Minimize production downtime.

  • Mike Wolfe
Mike Wolfe Jun 7, 2022 • 4 min read
Convert Common Access Field Defaults to SQL Server
Migration

Convert Common Access Field Defaults to SQL Server

Here's the Select Case statement I use to convert common Access field default calculations--Now(), Date(), etc.--to their SQL Server equivalents.

  • Mike Wolfe
Mike Wolfe Apr 21, 2022 • 1 min read
3 Gotchas of the SQL BETWEEN Statement
SQL Server

3 Gotchas of the SQL BETWEEN Statement

The SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.

  • Mike Wolfe
Mike Wolfe Dec 10, 2021 • 7 min read
Mystery of the Ancients
Migration

Mystery of the Ancients

The Ultimate Guide to Recovering Password-Protected, Access 97 Format .MDB Files

  • Mike Wolfe
Mike Wolfe Sep 1, 2021 • 5 min read
Yes/No Fields in SQL Server
SQL Server

Yes/No Fields in SQL Server

The SQL Server equivalent of an Access Yes/No field is the "bit" data type. Or is it?

  • Mike Wolfe
Mike Wolfe Jan 4, 2021 • 3 min read
No Longer Set © 2023
Powered by Ghost