Migrating to an SQL Server Database

For SQL Server, setup a link server relationship between the source databases and target databases, and execute a command like the following to move the data:

insert into prod.b.permit select * from dev.b.permit where serv_prov_code=’ALAMEDA’

where:

prod.b.permit

is the module configuration in the target database

dev.b.permit

is the permit module configuration in the source database

ALAMEDA

is the agency name.