SIGforum
Can you copy / paste or easily duplicate a (.BAK) file? SQL Server related
June 11, 2018, 12:54 PM
myrottietyCan you copy / paste or easily duplicate a (.BAK) file? SQL Server related
I'm doing a migration of CRM systems.
It's $500 for them to give me a copy of my database. Migrating it over to SQL Server .BAK file. It's a 75 GB file.
I need the data in x2 places. It's $500 per copy. If I pay for x1 copy. Is there a way for me to make a copy of the data. So I can have it on x2 USB drives. Drive one goes to CRM for sales team. Drive #2 goes to the new Applicant tracking system for the recruiting team.
I'll say I know virtually nothing about SQL from a dev or admin perspective. Just wondering if there is a easy way for me to duplicate & authenticate the data.
Train how you intend to Fight
Remember - Training is not sparring. Sparring is not fighting. Fighting is not combat. June 11, 2018, 01:26 PM
BytesI don't see why not? We copy SQL Server backups all the time. $500 per copy seems really steep for db that is that small. Once you get the first copy simply cut and paste to where you need to second one.
June 11, 2018, 01:55 PM
92fstechYep, no problem. .Bak file is just that...a file. You can copy it anywhere you want. What I'm not quite clear about is what you plan to do with it afterwards...are you restoring the same data into two different production systems?
June 11, 2018, 01:56 PM
Chancequote:
Originally posted by Bytes:
I don't see why not? We copy SQL Server backups all the time. $500 per copy seems really steep for db that is that small. Once you get the first copy simply cut and paste to where you need to second one.
I am guessing that should be copy and paste.
June 11, 2018, 01:58 PM
myrottietyquote:
Originally posted by 92fstech:
Yep, no problem. .Bak file is just that...a file. You can copy it anywhere you want. What I'm not quite clear about is what you plan to do with it afterwards...are you restoring the same data into two different production systems?
Exactly. I have one system now with Client Data & Candidate data.
The new system I'm going to will have client data on a CRM for the sales team. Then candidate data on a separate ATS (Applicant Tracking System). So I the data will need to be mapped differently to x2 separate systems. I want to be able to express mail the database to the new vendors for speed. That way I don't have to pass one USB stick around.
Train how you intend to Fight
Remember - Training is not sparring. Sparring is not fighting. Fighting is not combat. June 11, 2018, 02:00 PM
myrottietyquote:
$500 per copy seems really steep for db that is that small.
Exactly. That's why I wanted to make sure I could just rip a copy over to my hard drive. Then paste on a new USB drive.
Train how you intend to Fight
Remember - Training is not sparring. Sparring is not fighting. Fighting is not combat. June 11, 2018, 02:06 PM
WaterburyBobThat's exactly how I've always moved a SQL Database from one SQL Server to another - back-up, copy/paste, restore.
You'll probably also have to copy SQL Ids and do some security setup as needed.
"If Gun Control worked, Chicago would look like Mayberry, not Thunderdome" - Cam Edwards
June 11, 2018, 02:08 PM
stoic-onequote:
I want to be able to express mail the database to the new vendors for speed. That way I don't have to pass one USB stick around.
Dropbox or the like, and send them an email link to the data?
June 11, 2018, 02:14 PM
myrottietyquote:
Originally posted by WaterburyBob:
That's exactly how I've always moved a SQL Database from one SQL Server to another - back-up, copy/paste, restore.
You'll probably also have to copy SQL Ids and do some security setup as needed.
I'll basically just have access to the single .BAK file. The new software guys that receive the .BAK will have to do everything else. I just want to make sure I can get the data to x2 places at the same time. Without the extra $500 extortion charge.
Train how you intend to Fight
Remember - Training is not sparring. Sparring is not fighting. Fighting is not combat. June 12, 2018, 08:10 PM
92fstechquote:
Originally posted by myrottiety:
quote:
Originally posted by 92fstech:
Yep, no problem. .Bak file is just that...a file. You can copy it anywhere you want. What I'm not quite clear about is what you plan to do with it afterwards...are you restoring the same data into two different production systems?
Exactly. I have one system now with Client Data & Candidate data.
The new system I'm going to will have client data on a CRM for the sales team. Then candidate data on a separate ATS (Applicant Tracking System). So I the data will need to be mapped differently to x2 separate systems. I want to be able to express mail the database to the new vendors for speed. That way I don't have to pass one USB stick around.
I guess my big question is how are you going to keep your data current and synchronized when you have a separate copy in two separate systems? I've always been a fan of keeping data in one place and accessing that single data set from multiple systems, rather than the other way around.