Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 65
  • Last Modified:

Creating and importing data into a database using .sql files

We have created a new CRM deployment and pointed it to a new back end database that is running SQL Server 2008. We also have an existing deployment on SQL 2008 R2, which I would like to use a database off to test the new environment. The problem that I have is that the smallest database is 20GB, so when I script it out and convert it so that it is compatible with 2008 it is roughly 34GB in size, which means when I try and import it the .sql file it says there are not enough resources available. I have then exported it in several files (over 2000) and transferred them to the new server.

My question is - How do I know what order the new files should be imported in?

Any assistance would be appreciated
0
TVS-ServiceDesk
Asked:
TVS-ServiceDesk
  • 2
1 Solution
 
Chinmay PatelEnterprise ArchitectCommented:
I dont think you can do it this way. Did you try to import the database directly.
0
 
ZberteocCommented:
You can try this:

1. Like you said, generate a script with both structure and data for all your objects in the database (with create database option if the database doesn't exist on the target server) into 1 big .sql file, which then you will have to execute on the target using the SQLCMD utility from a command prompt window:

C:>sqlcmd -S myServer\instanceName -i C:\myScript.sql -E

2. Use the import export feature on any of the servers.

3. Use SSIS

4. Use snapshot replication
0
 
Chinmay PatelEnterprise ArchitectCommented:
Please try taking the DB files and try an upgrade. CRM doesnt allow direct database manipulation. Make sure you have all the required backups befor you try anything.
0
 
TVS-ServiceDeskAuthor Commented:
This worked a treat, thankyou very much for your assistance
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now